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;

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")
)

希望这能帮助解决问题。