thanks it worked :)
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Update-statement-doesn-t-work-tp5770031p5770068.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresq
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 =
Mohamedyousof wrote
> UPDATE "Categories" SET ("Name") = ('test') where "ID" = 28;
No parenthesis:
UPDATE "Categories" SET "Name" = 'test' WHERE "ID" = 28;
This presumes you truly need the double-quotes. It this does not work try
removing the double-quotes around "Categories", "Name" and "ID" a
David Johnston wrote
>
> Mohamedyousof wrote
>> UPDATE "Categories" SET ("Name") = ('test') where "ID" = 28;
> No parenthesis:
>
> UPDATE "Categories" SET "Name" = 'test' WHERE "ID" = 28;
>
> This presumes you truly need the double-quotes. It this does not work try
> removing the double-quotes
