Answers for "drop data reset identity postgresql"

postgresql reset auto increment

-- if you dont mind losing the data, do the following
TRUNCATE TABLE someTable RESTART IDENTITY;

Posted by: Guest on January-15-2021

postgresql reset serial counter after deleting content

ALTER SEQUENCE product_id_seq RESTART WITH 1453

Posted by: Guest on March-20-2020

Code answers related to "drop data reset identity postgresql"