CREATE SEQUENCE test_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE table_test ALTER COLUMN id SET DEFAULT nextval( 'test_id_seq' );
建表后操作table_test :表名称id:字段名称CREATE SEQUENCE test_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1;ALTER TABLE table_test ALTER COLUMN id SET DEFAULT nextval( 'test_id_seq' );