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.

Post the create table statement. – OMG Ponies Jul 2 '12 at 20:15 — OMG Ponies, Jul 2 '12 at 20:15

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

up vote 17 down vote accepted

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

193k26246322

answered Jul 2 '12 at 20:19

cybertextron

3,304741102

Worked great! Thnx. – user1449384 Jul 2 '12 at 20:23

add a comment |

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

up vote 6 down vote

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

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

answered Jul 2 '12 at 20:17

juergen d

128k21139204

add a comment |

2 Answers 2