On 17 Oct 2001, Arcady Genkin wrote:
> 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. :(
Oops, I thought you had made a typo, but I made a thinko. Use the -E
option to generate the S
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 f
Use psql -E and it will give you the SQL for the backslash commands..
-Mitch
- Original Message -
From: "Arcady Genkin" <[EMAIL PROTECTED]>
To: "PostgreSQL" <[EMAIL PROTECTED]>
Sent: Wednesday, October 17, 2001 4:35 PM
Subject: [GENERAL] SQL equiva
