Skip to content

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.

Are you intimidated by Git? Can’t figure out merge vs rebase? Are you afraid of screwing up something any time you have to do something in Git? Do you rely on ChatGPT or random people’s answer on StackOverflow to fix your problems? Your coworkers are tired of explaining Git to you all the time? Git is something we all need to use, but few of us really master it. I created this course to improve your Git (and GitHub) knowledge at a radical level. A course that helps you feel less frustrated with Git. Launching May 21, 2024. Join the waiting list!
→ Read my SQL Tutorial on The Valley of Code

Here is how can I help you: