CREATE SEQUENCE circlefence_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1;
alter table circlefence alter column id set default nextval(‘circlefence_id_seq‘);
【postgresql】创建自增SEQUENCE
原文：http://www.cnblogs.com/viewcozy/p/4792868.html
