How to select a list of sequences?

Поиск
Список
Период
Сортировка
От Kenneth Buckler
Тема How to select a list of sequences?
Дата
Msg-id AANLkTimOS6KMWtHL8WdFCU8am+run9_USzEs_prD-Drh@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to select a list of sequences?  (Raghavendra <raghavendra.rao@enterprisedb.com>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Vibhor Kumar
Дата:
Сообщение: Re: Pgdump error "invalid page header in block"
Следующее
От: Maximilian Tyrtania
Дата:
Сообщение: Re: invalid byte sequence