database - 列在 Postgresql 中不存在

Question

我创建了一个表:

CREATE TABLE LuxRoom
(
 roomID INT NOT NULL PRIMARY KEY CONSTRAINT roomID_ref_room REFERENCES Room(roomID),
 peopleNumber INT NOT NULL,
 additionalService TEXT
)

但是当我像这样插入时:

INSERT INTO LuxRoom(roomID, peopleNumber, additionalService) VALUES(1, 2, "Extra food, a cab");

我收到这个错误:

ERROR:  column "Extra food, a cab" does not exist

问题是什么？

Answer 1

Single quotes delimit a string constant or a date/time constant.

Double quotes delimit identifiers for e.g. table names or column names. This is generally only necessary when your identifier doesn't fit the rules for simple identifiers.

用单引号替换双引号

INSERT INTO LuxRoom (roomID, peopleNumber, additionalService) 
VALUES (1, 2, 'Extra food, a cab');