Re: FW: [ADMIN] reset all sequences

[Ben K.]

Select setval('mytable_id_seq',1);
So when I insert a new row the value will be "2" and not "1" as it should be

Select setval('mytable_id_seq',1,false);
http://www.postgresql.org/docs/8.1/interactive/functions-sequence.html


HTH.

Ben K.
Developer
http://benix.tamu.edu

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend