我一直在编写以下SQL脚本,但似乎无法弄清楚为什么它不断告诉我插入的数据位于不存在的列中。有更有经验的Postgre用户能帮我解决吗?
DROP SCHEMA pomodoro CASCADE;
CREATE SCHEMA pomodoro;
CREATE TABLE pomodoro.users
(
uid smallint NOT NULL,
username text NOT NULL,
password text NOT NULL,
weekly_goals bytea,
CONSTRAINT users_pkey PRIMARY KEY (uid)
) WITH (OIDS=FALSE);
INSERT INTO pomodoro.users (uid, username,password)
VALUES (1,"dan","pass");
我收到的错误是:
INSERT INTO pomodoro.users (uid, username,password)
VALUES (1,"dan","pass");
psql:database-backup/start-script.sql:27: ERROR: column "dan" does not exist
LINE 2: VALUES (1,"dan","pass");