Sequence ID - Reset in Postgresql
a look at CSS in a different way
When you have played around PostgreSQL tables, have you noticed by default the autoincrement type eg., id is not reset when you delete bunch of records and insert another set of records again, the inserted records get new incremented id not replacing the old ones that were just deleted from table.
To reset the auto-increment ID (or serial sequence) in a PostgreSQL table, you can use the ALTER SEQUENCE command or the SETVAL function.