jpescada/reset_postgresql_seq_key.sql

Created January 29, 2021 15:30

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jpescada/531c7b12571ce49c818e5cbdf627af0d.js"></script>
Save jpescada/531c7b12571ce49c818e5cbdf627af0d to your computer and use it in GitHub Desktop.

Download ZIP

Reset PostgreSQL sequence key

Raw

reset_postgresql_seq_key.sql

SELECT setval(pg_get_serial_sequence('table_name_here', 'id'), COALESCE((SELECT MAX(id) + 1 FROM table_name_here), 1), false);

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