create sequence xx_id_seq increment by 1 no maxvalue start with 1;
alter table 表名 alter column 字段 set default nextval('xx_id_seq');
update 表名 set 字段 = nextval('xx_id_seq');
示例:
create sequence test_1_id_seq increment by 1 no maxvalue start with 1;
alter table test_1 alter column id set default nextval('test_1_id_seq');
update test_1 set id = nextval('test_1_id_seq');
结果: