how to reset auto increment id in postgresql code example
Example 1: postgresql reset auto increment
-- if you dont mind losing the data, do the following
TRUNCATE TABLE someTable RESTART IDENTITY;
Example 2: postgresql reset auto_increment index
-- Change the starting value of the sequence
ALTER SEQUENCE project_id_seq RESTART 3000;
-- Same but dynamic :
SELECT SETVAL('project_id_seq', (SELECT MAX(id) + 1 FROM project));