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

On 17 Oct 2001, Arcady Genkin wrote:

> 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.

\ds *is* the psql command for listing sequences:

arc=> create sequence testme;
CREATE
arc=> \ds
       List of relations
  Name  |   Type   |   Owner
--------+----------+-----------
 testme | sequence | arc_admin
(1 row)

-- Brett
                                          http://www.chapelperilous.net/
------------------------------------------------------------------------
Thrashing is just virtual crashing.