Postgres Pro
Downloads
Home   >   mailing lists

Thread: Reset sequence number

Reset sequence number

From
Marc
Date:
Hello,

How can I reset a sequence number back to 0 ?

Regards

Re: Reset sequence number

From
missive@frontiernet.net (Lee Harr)
Date:
> How can I reset a sequence number back to 0 ?
>

SELECT setval('sequence_name', 0);


In order for this to work, the sequence must have been created with
a MINVALUE of 0 (the default MINVALUE is 1)

CREATE SEQUENCE sequence_name MINVALUE 0;

Re: Reset sequence number

From
Bruno Wolff III
Date:
On Sat, Feb 23, 2002 at 05:07:34PM +0000,
  Lee Harr <missive@frontiernet.net> wrote:
> > How can I reset a sequence number back to 0 ?
> >
>
> SELECT setval('sequence_name', 0);
>
>
> In order for this to work, the sequence must have been created with
> a MINVALUE of 0 (the default MINVALUE is 1)
>
> CREATE SEQUENCE sequence_name MINVALUE 0;

Note, that if you do it this way, 1 will be the next sequent number returned
by nextval. If you want 0 to be returned next use setval('seq_name', 0, false).

Re: Reset sequence number

From
"Lonh SENG"
Date:
I use truncate table $table_name.
This will delete all data from that table and reset the sequense number.
----- Original Message -----
From: "Marc" <syn_uw@nospan_hotmail.com>
To: <pgsql-admin@postgresql.org>
Sent: Saturday, February 23, 2002 6:37 PM
Subject: [ADMIN] Reset sequence number


> Hello,
>
> How can I reset a sequence number back to 0 ?
>
> Regards
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>