シーケンスオブジェクトの値の更新
SELECT MAX(id) FROM table;
SELECT nextval('table_id_seq');
SELECT setval('table_id_seq', (SELECT MAX(id) FROM table));
PostgreSQLの自動採番をなおす
a min to read
tama-tan
posts
SELECT MAX(id) FROM table;
SELECT nextval('table_id_seq');
SELECT setval('table_id_seq', (SELECT MAX(id) FROM table));