PostgreSQL 主键自动增长

建立主键并设置自动增加的办法好好几种，这里记录我测试过的：

1drop table pro_process;
2CREATE TABLE "public"."pro_process" (
3"id" SERIAL primary key,  //设置主键并自动增长
4"county_code" varchar(6) COLLATE "default" NOT NULL,
5"county_name" varchar(50) COLLATE "default" NOT NULL,
6"creator" varchar(100) COLLATE "default" NOT NULL,
7"create_time" date NOT NULL
8)
9WITH (OIDS=FALSE)
10;
11
12ALTER TABLE "public"."pro_process" OWNER TO "postgres";

参考：

http://blog.csdn.net/dracotianlong/article/details/7946035