postgressql创建表主键自增

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