| From: | "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net> |
|---|---|
| To: | Arcady Genkin <a(dot)genkin(at)utoronto(dot)ca> |
| Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: SQL equivallent to "\ds" in psql |
| Date: | 2001-10-18 04:00:44 |
| Message-ID: | Pine.LNX.4.30.0110172359320.31857-100000@chapelperilous.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brett W. McCoy | 2001-10-18 04:03:44 | Re: SQL equivallent to "\ds" in psql |
| Previous Message | Flancer | 2001-10-18 03:47:12 | Break both? (Was To Postgres Devs : Wouldn't changing the select limit ) |