How to reset Postgres SERIAL number
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.
→ Download my free SQL Handbook!
THE VALLEY OF CODE
THE WEB DEVELOPER's MANUAL
You might be interested in those things I do:
- Learn to code in THE VALLEY OF CODE, your your web development manual
- Find a ton of Web Development projects to learn modern tech stacks in practice in THE VALLEY OF CODE PRO
- I wrote 16 books for beginner software developers, DOWNLOAD THEM NOW
- Every year I organize a hands-on cohort course coding BOOTCAMP to teach you how to build a complex, modern Web Application in practice (next edition February-March-April-May 2024)
- Learn how to start a solopreneur business on the Internet with SOLO LAB (next edition in 2024)
- Find me on X