Horton

Re: SQL equivallent to "\ds" in psql

Brett W. McCoy <bmccoy@chapelperilous.net>

View thread View on postgr.es
From: "Brett W. McCoy" <bmccoy@chapelperilous.net>
To: Arcady Genkin <a.genkin@utoronto.ca>
Cc: PostgreSQL <pgsql-general@postgresql.org>
Date: 2001-10-18T04:00:44Z
Lists: 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.