查找表中最大的id SELECT MAX(id) FROM scholars; 查找自增的id最大值 SELECT nextval(’{表名}_id_seq’); 修改自增id最大值 SELECT setval(’{表名}_id_seq’, (SELECT MAX(id) FROM scholars)); 检查 SELECT nextval(‘scholars_id_seq’); 转载于:https://segmentfault.com/q/1010000007145119