SQL equivallent to "\ds" in psql

Поиск
Список
Период
Сортировка
От Arcady Genkin
Тема SQL equivallent to "\ds" in psql
Дата
Msg-id r1zlmiaypgx.fsf@bashful.cdf.toronto.edu
обсуждение исходный текст
Ответы Re: SQL equivallent to "\ds" in psql  (Jason Earl <jdearl@yahoo.com>)
Re: SQL equivallent to "\ds" in psql  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
Re: SQL equivallent to "\ds" in psql  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
Список pgsql-general
Where does Postgres store information about the sequences?  I tried
looking in the tables produced by "\dS", but could find no references
to the sequences. :(

What I want is an SQL equivallent of "\ds" command, which will return
a list of all sequences in the current database.  I need this for a
periodically run script so that I could keep an eye on all sequences
in the database.

Many thanks,
--
Arcady Genkin

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: To Postgres Devs : Wouldn't changing the select limit
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Blank SQL insert statements