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