-- 创建序列
CREATE SEQUENCE tb_file_attachment_id_seq;
-- 修改表,将 id 列设为主键,并将其默认值设置为序列的下一个值
ALTER TABLE tb_file_attachment
ALTER COLUMN id SET DEFAULT nextval('tb_file_attachment_id_seq');
-- 设置序列的起始值和自增步长
SELECT setval('tb_file_attachment_id_seq', (SELECT MAX(id) FROM tb_file_attachment), true);