Postgres Pro
Downloads
Home   >   mailing lists

SQL equivallent to "\ds" in psql - Mailing list pgsql-general

From Arcady Genkin
Subject SQL equivallent to "\ds" in psql
Date
Msg-id r1zlmiaypgx.fsf@bashful.cdf.toronto.edu
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: To Postgres Devs : Wouldn't changing the select limit
Next
From: Peter Eisentraut
Date:
Subject: Re: Blank SQL insert statements