| From: | Andreas 'ads' Scherbaum <adsmail(at)wars-nicht(dot)de> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: SHOW TABLES |
| Date: | 2010-07-15 19:27:30 |
| Message-ID: | 20100715212730.2eb11dca@platin.wars-nicht.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, 15 Jul 2010 22:01:34 +0300 Peter Eisentraut wrote:
> On tor, 2010-07-15 at 19:21 +0200, Andreas 'ads' Scherbaum wrote:
> > Is there a way to query all databases from information_schema?
>
> No.
This got rejected before, because of "not in the standard".
In this case: no way to answer "SHOW DATABASES" by just using
information_schema. At least this question requires using the system
tables.
Bye
--
Andreas 'ads' Scherbaum
German PostgreSQL User Group
European PostgreSQL User Group - Board of Directors
Volunteer Regional Contact, Germany - PostgreSQL Project
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2010-07-15 19:38:32 | Re: SHOW TABLES |
| Previous Message | Richard Huxton | 2010-07-15 19:26:18 | Re: SHOW TABLES |