sql - 在 PGadmin4 中创建表时出现逗号抛出错误

Question

尝试在 PGadmin 中生成表时，出现以下错误：

ERROR:  syntax error at or near ","
LINE 3:     "ID" integer NOT NULL DEFAULT,    
                                         ^

为什么不喜欢逗号？这是PGadmin生成的sql，奇怪它不喜欢自己的sql。

CREATE TABLE public.email_list
(
    "ID" integer NOT NULL DEFAULT,
    "FIRST NAME" "char",
    "LAST NAME" "char",
    "EMAIL" "char",
    "TITLE" "char",
    "LOCATION" "char",
    "COMPANY WEBSITE" "char",
    "COMPANY TYPE" numeric,
    "DATE ADDED" timestamp with time zone,
    "LAST CONTACT DATE" date,
    "STATUS CODE" "char",
    CONSTRAINT "ID" PRIMARY KEY ("ID")
)

TABLESPACE pg_default;

ALTER TABLE public.email_lists
    OWNER to postgres;

标签： sqlpostgresqlddl

Answer 1

当第一次查看您的查询时，我发现有些东西看起来不合适，这里我展示了我是如何修复它的。

CREATE TABLE public.email_list
(
    "ID" integer NOT NULL DEFAULT, <<-- You have to set DEFAULT follow with some value e.g : DEFAULT 0, or u can remove the DEFAULT keyword instead.
    "FIRST NAME" "char",
    "LAST NAME" "char",
    "EMAIL" "char",
    "TITLE" "char",
    "LOCATION" "char",
    "COMPANY WEBSITE" "char",
    "COMPANY TYPE" numeric,
    "DATE ADDED" timestamp with time zone,
    "LAST CONTACT DATE" date,
    "STATUS CODE" "char",
    CONSTRAINT "ID" PRIMARY KEY ("ID")
)

希望这可以帮助解决问题。