CODE EXAMPLE FOR SQL

postgres advance auto increment

# Reset the counter of a table named yourTable to start at id # 1453
ALTER SEQUENCE yourTable_id_seq RESTART WITH 1453