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
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
