Postgres Pro
Downloads
Home   >   mailing lists

reset all sequences - Mailing list pgsql-admin

From Sriram Dandapani
Subject reset all sequences
Date
Msg-id 6992E470F12A444BB787B5C937B9D4DF041C36B1@ca-mail1.cis.local
Whole thread Raw
Responses Re: reset all sequences  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-admin
Tree view

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)

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to find current running process
Next
From: "Mark Liberman"
Date:
Subject: Re: Tale partitioning