Question : postgres advance auto increment
Answered by : trained-tuna
# Reset the counter of a table named yourTable to start at id # 1453
ALTER SEQUENCE yourTable_id_seq RESTART WITH 1453
Source : https://stackoverflow.com/questions/5342440/reset-auto-increment-counter-in-postgres | Last Update : Mon, 21 Mar 22