Postgres 更新列数据时出错

尝试在表上运行更新脚本，但出现错误：

错误：“ok”列不存在 第 2 行：设置first_name =“ok”，last_name =“pk”，电子邮件=“ooo”，电话=“...

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;

不需要将表名用双引号引起来"employee"，并对列值使用单引号

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

请参阅工作示例