Postgres error updating column data

Question

Trying to run a update script on a table, but getting an error:

ERROR: column "ok" does not exist LINE 2: SET first_name="ok", last_name="pk", email="ooo", phone="...

CREATE TABLE employee (
   employee_id      SERIAL PRIMARY KEY,
   first_name       varchar(255)                NOT NULL,
   last_name        varchar(255)                NOT NULL,
   email            varchar(255)                NOT NULL,
   phone            varchar(255)
);


INSERT INTO employee(
            first_name, last_name, email, phone)
    VALUES ('Kyle', 'Belanger', '[email protected]', '(240) 298-4664');


UPDATE "employee"
   SET first_name="ok", last_name="pk", email="ooo", phone="000"
 WHERE employee_id = 1;

"ok" is a column name, not a string literal. Please read the manual: postgresql.org/docs/current/static/… — user330315
– user330315, Commented Jun 11, 2015 at 5:55

HaveNoDisplayName · Accepted Answer · 2015-06-10 19:02:14Z

5

There is no need to wrap table name in double quote "employee", and use single quotes for column values

UPDATE employee   
   SET first_name='ok', last_name='pk', email='ooo', phone='000'
 WHERE employee_id = 1;

See Working Example

answered Jun 10, 2015 at 19:02

HaveNoDisplayName

8,537106 gold badges41 silver badges50 bronze badges

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

Comments

Explorer · Accepted Answer · 2015-06-10 19:13:57Z

1

Try below sql:

 UPDATE employee
   SET first_name='ok', last_name='pk', email='ooo', phone='000'
 WHERE employee_id = 1;

Table name was wrapped in double quotes which is not allowed.

edited Jun 10, 2015 at 19:13

answered Jun 10, 2015 at 19:03

Explorer

1,6775 gold badges30 silver badges74 bronze badges

4 Comments

HaveNoDisplayName Over a year ago

even column values also need single quote only, not double quotes

Explorer Over a year ago

I am not sure about it but the above query worked in sql fiddle.

HaveNoDisplayName Over a year ago

see this , SQL fiddle for your query sqlfiddle.com/#!15/93c2a/10. Share your fiddle which is working?

Explorer Over a year ago

I changed it. I did ran it with single quote in sql fiddle. Thanks for pointing it out. (up-vote for your suggestion :) )

Collectives™ on Stack Overflow

Postgres error updating column data

2 Answers 2

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related