Thread: reset all sequences

reset all sequences

From
"Sriram Dandapani"
Date:

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)

Re: reset all sequences

From
Bruno Wolff III
Date:
On Thu, May 04, 2006 at 14:20:39 -0700,
  Sriram Dandapani <sdandapani@counterpane.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.

Re: reset all sequences

From
"Sriram Dandapani"
Date:
Thanks..that really helped!!

-----Original Message-----
From: Bruno Wolff III [mailto:bruno@wolff.to]
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 <sdandapani@counterpane.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.