|
Hi How
can I reset the sequence to “1” If
I use the following statement Select
setval('mytable_id_seq',1); I
put the last value as 1 So
when I insert a new row the value will be “2”
and not “1” as it
should be I
cannot put Select setval('mytable_id_seq',0); What
should I do ??!! Thx Pascal -----Original
Message----- Thanks..that
really helped!! -----Original
Message----- From:
Bruno Wolff III [mailto:bruno@xxxxxxxx] Sent:
Thursday, May 04, 2006 7:44 PM To:
Sriram Dandapani Cc:
Subject:
Re: reset all sequences On
Thu, May 04, 2006 at 14:20:39 -0700,
Sriram Dandapani <sdandapani@xxxxxxxxxxxxxxx> wrote: >
Hi >
>
>
>
I have a scenario where I need to reset all sequences(about 400). Is >
there a system table that I can query to get a list of sequences >
(Postgres 8.1.x) You
can do something like: select
* from pg_class where relkind = 'S'; The
relname column will give you the sequence name. ---------------------------(end
of broadcast)--------------------------- TIP
1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly |
