Kyle
Kyle

Reputation: 1173

Postgres error updating column data

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;

Upvotes: 2

Views: 6890

Answers (2)

Explorer
Explorer

Reputation: 1647

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.

Upvotes: 1

HaveNoDisplayName
HaveNoDisplayName

Reputation: 8517

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

Upvotes: 5

Related Questions