Re: SQL equivallent to "\ds" in psql
От | Mitch Vincent |
---|---|
Тема | Re: SQL equivallent to "\ds" in psql |
Дата | |
Msg-id | 003601c15753$22f6b460$e05c5dd8@mitch обсуждение исходный текст |
Ответ на | SQL equivallent to "\ds" in psql (Arcady Genkin <a.genkin@utoronto.ca>) |
Список | pgsql-general |
Use psql -E and it will give you the SQL for the backslash commands.. -Mitch ----- Original Message ----- From: "Arcady Genkin" <a.genkin@utoronto.ca> To: "PostgreSQL" <pgsql-general@postgresql.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 >
В списке pgsql-general по дате отправления: