Postgres为什么会说列不存在？

Question

我一直在编写以下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");

- bmacrevolution

---

单引号用于字符串，双引号用于列名。 - Vamsi Prabhala

谢谢！那个起作用了。 - bmacrevolution

Answer 1

双引号用于指定列名，因此您可以像这样插入：

INSERT INTO pomodoro.users (uid, username,password) VALUES (1,'dan','pass');

- parlad