Update statement doesn't work

Hi everybody 

I have table called "Categories" with 2 cols "ID" and "Name" 
when I type update statement like this I got error

UPDATE "Categories" SET ("Name") = ('test') where "ID" = 28;

error:

ERROR:  column "name" of relation "Categories" does not exist
LINE 1: UPDATE "Categories" SET Name = '';

can anyone help on this please?

thanks in advance



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Update-statement-doesn-t-work-tp5770031.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.