Re: reset all sequences

Thanks..that really helped!!

-----Original Message-----
From: Bruno Wolff III [mailto:bruno(at)wolff(dot)to]
Sent: Thursday, May 04, 2006 7:44 PM
To: Sriram Dandapani
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: reset all sequences

On Thu, May 04, 2006 at 14:20:39 -0700,
Sriram Dandapani <sdandapani(at)counterpane(dot)com> 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.