pgsql添加自增序列、设置表某个字段自增操作

添加自增序列

CREATE SEQUENCE 表名_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;