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.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
