Update column value PostgreSQL

Question

I am trying to update the value of a column where it matches a certain userid, but it keeps giving a syntax error.

UPDATE user 
   SET balance = 15000.000000000 
 WHERE id = 11203;

The table called user has many rows with two columns, balance and id. I am trying to edit the balance of the user id in the code.

cybertextron · Accepted Answer · 2012-07-02 21:02:09Z

80

Try "user", or give a more generic name:

UPDATE "user" 
 SET balance = 15000.000000000 
 WHERE id = 11203;

or ALTER your table name to "user_list" for example. Any doubt, please check keywords

user330315

answered Jul 2, 2012 at 20:19

cybertextron

11k32 gold badges117 silver badges220 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

juergen d · Accepted Answer · 2012-07-02 20:17:47Z

18

You need to escape user since it is a reserved word. Try

UPDATE "user"
SET balance = 15000.000000000 
WHERE id = 11203;

answered Jul 2, 2012 at 20:17

juergen d

205k40 gold badges305 silver badges377 bronze badges