SQL equivallent to "\ds" in psql
Arcady Genkin <a.genkin@utoronto.ca>
From: Arcady Genkin <a.genkin@utoronto.ca>
To: PostgreSQL <pgsql-general@postgresql.org>
Date: 2001-10-17T20:35:26Z
Lists: pgsql-general
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