Skip to content

Instantly share code, notes, and snippets.

@yuhangch

yuhangch/id_seq.sql

Created June 1, 2020 12:58
Show Gist options
  • Save yuhangch/835fdc7ccdfdb507b9ba6929f77b5922 to your computer and use it in GitHub Desktop.
Save yuhangch/835fdc7ccdfdb507b9ba6929f77b5922 to your computer and use it in GitHub Desktop.
Download ZIP
Update Auto Increasing ID Next Value in PostgreSQL.
Raw
id_seq.sql
select setval('record_id_seq', (select max(id) from record));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment