Re: How to select a list of sequences?
| От | Raghavendra |
|---|---|
| Тема | Re: How to select a list of sequences? |
| Дата | |
| Msg-id | AANLkTi=z7tbJUWUMz7qyfniJ5kWstp5Hr5w6fgZ2ARt5@mail.gmail.com обсуждение исходный текст |
| Ответ на | How to select a list of sequences? (Kenneth Buckler <kenneth.buckler@gmail.com>) |
| Ответы |
Re: How to select a list of sequences?
|
| Список | pgsql-general |
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
EnterpriseDB Corporation
The Enterprise Postgres Company
On Fri, Mar 4, 2011 at 7:32 PM, Kenneth Buckler <kenneth.buckler@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
В списке pgsql-general по дате отправления: