Thanks..that really helped!!
-----Original Message-----
From: Bruno Wolff III [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 04, 2006 7:44 PM
To: Sriram Dandapani
Cc: pgsql-admin@postgresql.org
Subject: Re: reset all sequences
On Thu, May 04, 2006 at 14:20:39 -0700,
Sriram Dandapani <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
