Re: SQL equivallent to "\ds" in psql

Use psql -E and it will give you the SQL for the backslash commands..

-Mitch

----- Original Message -----
From: "Arcady Genkin" <a(dot)genkin(at)utoronto(dot)ca>
To: "PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, October 17, 2001 4:35 PM
Subject: [GENERAL] SQL equivallent to "\ds" in psql

> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>