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

[Nico Grubert]

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org