-- 获取表id最大值
select max(id) from tablename;
-- 修改序列
alter sequence sequence_name by 1 restart with 1442;
-- 验证下次序列号
select nextval(‘sequence_name‘);
PostgreSql 重置序列起始值
原文:https://www.cnblogs.com/pretty-ru/p/11929080.html