On Thu, May 04, 2006 at 14:20:39 -0700, Sriram Dandapani <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
