Answers for "how to reset the auto_increment value in postgres"

SQL
0

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));
Posted by: Guest on September-10-2020

Code answers related to "how to reset the auto_increment value in postgres"

Code answers related to "SQL"

Browse Popular Code Answers by Language