Re: Reset sequence number - Mailing list pgsql-admin

> How can I reset a sequence number back to 0 ?
>

SELECT setval('sequence_name', 0);


In order for this to work, the sequence must have been created with
a MINVALUE of 0 (the default MINVALUE is 1)

CREATE SEQUENCE sequence_name MINVALUE 0;