> 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 witha MINVALUE of 0 (the default MINVALUE is 1)
CREATE SEQUENCE sequence_name MINVALUE 0;