自增序列
在创建表时添加自增序列:
CREATE SEQUENCE incremental_test1_id_seq
START WITH 1
INCREMENT by 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE incremental_test1 ALTER COLUMN id SET DEFAULT nextval('incremental_test1_id_seq');
将自增序列重置为1
ALTER SEQUENCE incremental_test1_id_seq RESTART WITH 1;
对于已存在数据的表添加自增字段:
ALTER TABLE incremental_test2 add incr_id serial not NULL;