reset all sequences

From: "Sriram Dandapani" <sdandapani(at)counterpane(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: reset all sequences
Date: 2006-05-04 21:20:39
Message-ID: 6992E470F12A444BB787B5C937B9D4DF041C36B1@ca-mail1.cis.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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)

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mark Liberman 2006-05-05 01:48:25 Re: Tale partitioning
Previous Message Vadim Pestovnikov 2006-05-04 20:50:53 Python os.system module handle errors