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.


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Reply via email to