Thread

Re: SQL equivallent to "\ds" in psql

Creager, Robert S <creagrs@louisville.stortek.com> — 2001-10-17T21:28:10Z

execute psql with a -E option, then do \ds.  You'll see the queries sent to
the backend.

Later,
Rob

> -----Original Message-----
> From: Arcady Genkin [mailto:a.genkin@utoronto.ca]
> Sent: Wednesday, October 17, 2001 2:35 PM
> To: PostgreSQL
> 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
>