Thank you. Please do add 'pgsql-general@postgresql.org' while replying.
Best Regards, Raghavendra EnterpriseDB Corporation The Enterprise Postgres Company On Fri, Mar 4, 2011 at 8:04 PM, Kenneth Buckler <kenneth.buck...@gmail.com>wrote: > Perfect! Thanks a bunch! > > Ken > > On Fri, Mar 4, 2011 at 9:31 AM, Raghavendra > <raghavendra....@enterprisedb.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.buck...@gmail.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@postgresql.org) > >> To make changes to your subscription: > >> http://www.postgresql.org/mailpref/pgsql-general > > > > >
