1、创建序列

CREATE SEQUENCE
report_id_seq
INCREMENT 1
MINVALUE 1
START WITH 1;

2、设置关联

ALTER TABLE report ALTER COLUMN "id" SET DEFAULT NEXTVAL('report_id_seq');

CREATE SEQUENCE
report_id_seq
INCREMENT 1
MINVALUE 1
START WITH 1;

ALTER TABLE report ALTER COLUMN "id" SET DEFAULT NEXTVAL('report_id_seq');