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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
