postgresql中主键自增需要借助sequence实现,类似oracle,操作如下,
首先建立sequence:
create SEQUENCE ad.big_table_ship
INCREMENT 1
START 1
MINVALUE 1
MAXVALUE 999999999999
CACHE 1;
ALTER SEQUENCE ad.big_table_ship
OWNER TO postgres;
然后建表:
CREATE TABLE "ad"."ad_big_table" (
"info_key" int8 DEFAULT nextval('"ad".big_table_ship'::regclass),
"profile_id" int4,
"gsadid" varchar(32) COLLATE "default" NOT NULL,
CONSTRAINT "ad_big_table_new_pkey" PRIMARY KEY ("gsadid")
)
WITH (OIDS=FALSE)
;
ALTER TABLE "ad"."ad_big_table" OWNER TO "postgres";