pgsql自动自增实现

创建序列

CREATE SEQUENCE sequence_name START WITH 1 INCREMENT BY 1 NO MAXVALUE NO CYCLE; 

关联表

ALTER TABLE my_table ALTER COLUMN id SET DEFAULT nextval('sequence_name');

修改序列

alter sequence sequence_name restart with 20000001

查看序列

SELECT currval('sequence_name');

查看下一个序列

SELECT nextval('sequence_name');