Re: How to reset a sequence so it will start with 1 again?

[Nico Grubert <nicogrubert@xxxxxxxxx>]

> 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

Thanks Michael,

SELECT setval('tblperson_id_seq', 1, false);
will do exactly what I supposed to get.

Nico