Update statement doesn't work

From: Mohamedyousof <muhamed(dot)yousof(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Update statement doesn't work
Date: 2013-09-07 19:57:44
Message-ID: 1378583864149-5770031.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message David Johnston 2013-09-08 02:18:29 Re: Update statement doesn't work
Previous Message Paragon Corporation 2013-09-07 18:06:37 Parallel Jobs option feature for backup