Re: FW: reset all sequences

["Ben K." <bkim@xxxxxxxxxxxx>]

> 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