Re: How to select a list of sequences?

Thank you.

Please do add 'pgsql-general(at)postgresql(dot)org' while replying.

Best Regards,
Raghavendra
EnterpriseDB Corporation
The Enterprise Postgres Company

On Fri, Mar 4, 2011 at 8:04 PM, Kenneth Buckler
<kenneth(dot)buckler(at)gmail(dot)com>wrote:

> Perfect! Thanks a bunch!
>
> Ken
>
> On Fri, Mar 4, 2011 at 9:31 AM, Raghavendra
> <raghavendra(dot)rao(at)enterprisedb(dot)com> wrote:
> > Hi Kenneth,
> > You can retrieve the sequence information from the pg_catalog
> > "pg_statio_all_sequences"
> > or
> > select * from pg_class where relkind='S'
> > Best Regards,
> > Raghavendra
> > EnterpriseDB Corporation
> > The Enterprise Postgres Company
> >
> >
> > On Fri, Mar 4, 2011 at 7:32 PM, Kenneth Buckler <
> kenneth(dot)buckler(at)gmail(dot)com>
> > wrote:
> >>
> >> How can I select a list of sequences in Postgres 8.4?
> >>
> >> I'm writing functions which select names of tables, tablespaces,
> >> sequences, etc.
> >>
> >> For example, I can select a list of table names using the following
> >> command:
> >>
> >> SELECT tablename FROM pg_tables WHERE schemaname = 'public';
> >>
> >> However, I can't seem to find a view of sequences.
> >>
> >> I'm sure it's in there, as you can display a list of sequences using
> >> the \ds command, but that doesn't really help me here.
> >>
> >> Any help?
> >>
> >> Thanks,
> >>
> >> Ken
> >>
> >> --
> >> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> >> To make changes to your subscription:
> >> http://www.postgresql.org/mailpref/pgsql-general
> >
> >
>