Home > mailing lists

Re: FW: reset all sequences - Mailing list pgsql-admin

From	Ben K.
Subject	Re: FW: reset all sequences
Date	May 9, 2006 14:03:47
Msg-id	Pine.GSO.4.64.0605090859250.4784@coe.tamu.edu Whole thread Raw
In response to	FW: reset all sequences ("Pascal Tufenkji" <ptufenkji@usj.edu.lb>)
List	pgsql-admin

Tree view

> 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

pgsql-admin by date:

From: "Andy Shellam"
Date: 09 May 2006, 13:06:45
Subject: Re: Locallhost Windows installation

From:
Date: 09 May 2006, 20:47:34
Subject:

Re: FW: reset all sequences - Mailing list pgsql-admin

Previous

Next