Re: How to reset a sequence so it will start with 1 again? - Mailing list pgsql-general

On Jan 13, 2006, at 17:02 , Nico Grubert wrote:
>  SELECT setval('tblperson_id_seq', 1);

> Any idea, how I can reset the sequence so it will start with 1 again?

Take a look at the docs, in particular the three-parameter version of
setval and the is_called flag.
http://www.postgresql.org/docs/current/interactive/functions-
sequence.html

Michael Glaesemann
grzm myrealbox com