Skip to content

Instantly share code, notes, and snippets.

@henriquemenezes
Created March 31, 2016 12:23
Show Gist options
  • Save henriquemenezes/962829815e8e7875f5f4376133b2f209 to your computer and use it in GitHub Desktop.
Save henriquemenezes/962829815e8e7875f5f4376133b2f209 to your computer and use it in GitHub Desktop.
PostgreSQL set Next ID Sequence Value to MAX(id) from Table
-- 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));
@joedave13
Copy link

Thank you!

@naimurhasan
Copy link

thanks

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment