How to reset Postgres SERIAL number
New Course Coming Soon:
Get Really Good at Git
When testing a table with a SERIAL
field, this number will grow even if you remove all items in the table (like you’d do during testing), so you might insert a value and its id is 15
for example.
To restart the sequence from 1
, run the SQL query:
ALTER SEQUENCE TABLENAME_id_seq RESTART
Replace TABLENAME
with your table name, like:
ALTER SEQUENCE users_id_seq RESTART
Using TablePlus you have the option to reset the sequence when you truncate a table to remove its content.
→ Read my SQL Tutorial on
The Valley of Code
Here is how can I help you:
- COURSES where I teach everything I know
- CODING BOOTCAMP cohort course - next edition in 2025
- BOOKS 16 coding ebooks you can download for free on JS Python C PHP and lots more
- Follow me on X