能正确实行的SQL:
CREATE TABLE "public"."user_info_tbl" (
"id" INT DEFAULT "public"."UserInfoTbl_id_seq".nextval NOT NULL,
"username" VARCHAR ( 32 ) NOT NULL,
"password" VARCHAR ( 128 ) NOT NULL,
"privilege" VARCHAR ( 8 ) NOT NULL,
"login_time" TIMESTAMP ( 6 ) NULL,
"upd_time" TIMESTAMP ( 6 ) NULL,
"manager" VARCHAR ( 32 ) NULL,
"del_flag" VARCHAR ( 1 ) NOT NULL,
"menu" VARCHAR ( 1024 ) NULL,
"dept_id" VARCHAR ( 50 ) NULL,
PRIMARY KEY ( "id" )
);
执行报错的SQL 对象[id]DEFAULT约束表达式无效
CREATE TABLE "public"."non_ag_com_geo_tbl" (
"id" INT DEFAULT "public"."合并输出 _id_seq".nextval NOT NULL,
"geom" SYSGEO2.ST_GEOMETRY NULL,
"city" VARCHAR ( 100 ) NULL,
"province" VARCHAR ( 100 ) NULL,
"district" VARCHAR ( 100 ) NULL,
"version_year" VARCHAR ( 8 ) NULL,
"del_flag" VARCHAR ( 1 ) NULL,
"login_time" TIMESTAMP ( 6 ) NULL,
"upd_time" TIMESTAMP ( 6 ) NULL,
"manager" VARCHAR ( 32 ) NULL,
PRIMARY KEY ( "id" )
);
序列都在的:
大佬们,这该如何解决
合并输出 _id_seq
已解决,识别的时候怎么有空格。。