Skip to content

Instantly share code, notes, and snippets.

@zmts

zmts/postgresql-set-id-seq.sql

Forked from henriquemenezes/postgresql-set-id-seq.sql
Created April 25, 2019 15:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save zmts/60c7d5d90c0daabb821c1c9caec46fd5 to your computer and use it in GitHub Desktop.
Save zmts/60c7d5d90c0daabb821c1c9caec46fd5 to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL set Next ID Sequence Value to MAX(id) from Table
Raw
postgresql-set-id-seq.sql
-- Get Max ID from table
SELECT MAX(id) FROM table;
-- Get Next ID from table
SELECT nextval('table_id_seq');
-- Set Next ID Value to MAX ID
SELECT setval('table_id_seq', (SELECT MAX(id) FROM table));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment