On Thu, May 04, 2006 at 14:20:39 -0700, Sriram Dandapani <sdandapani@xxxxxxxxxxxxxxx> 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.
