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 >
