Answers for "reset serial id postgres"

CSS
1

reset id sequence postgres

alter sequence <tableName>_id_seq restart with 1;
For an instance, we have a table named "groups" and we need to reset the id sequence with 1. 
alter sequence groups_id_seq restart with 1;
Posted by: Guest on July-06-2020
1

postgresql reset serial counter after deleting content

ALTER SEQUENCE product_id_seq RESTART WITH 1453
Posted by: Guest on March-20-2020

Browse Popular Code Answers by Language