Skip to content

Instantly share code, notes, and snippets.

@pierot

pierot/Reset Postgres sequence auto increment.sql

Last active July 25, 2019 07:25
Show Gist options
  • Save pierot/774c25eda7f4d5099acefd459745e3d0 to your computer and use it in GitHub Desktop.
Save pierot/774c25eda7f4d5099acefd459745e3d0 to your computer and use it in GitHub Desktop.
Download ZIP
Reset Postgres sequence auto increment
Raw
Reset Postgres sequence auto increment.sql
ALTER SEQUENCE name_id_seq RESTART WITH 10000;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment