Skip to content

Latest commit

 

History

History
14 lines (11 loc) · 479 Bytes

restart-a-sequence.md

File metadata and controls

14 lines (11 loc) · 479 Bytes

Restart A Sequence

In postgres, if you are truncating a table or doing some other sort of destructive action on a table in a development or testing environment, you may notice that the id sequence for the primary key just keeps plugging along from where it last left off. The sequence can be reset to any value like so:

> alter sequence my_table_id_seq restart with 1;
ALTER SEQUENCE

source