goravbhootra/reset_pg_sequence.md

Created December 2, 2019 05:26

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/goravbhootra/978a8564a9085f78ba18e7935f1de5cf.js"></script>
Save goravbhootra/978a8564a9085f78ba18e7935f1de5cf to your computer and use it in GitHub Desktop.

Download ZIP

Reset sequence of pg table

Raw

reset_pg_sequence.md

postgres# Select setval('zones_id_seq', (SELECT max(id) from zones));

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