Re: SHOW TABLES - Mailing list pgsql-hackers

From Andreas 'ads' Scherbaum
Subject Re: SHOW TABLES
Date
Msg-id 20100715212730.2eb11dca@platin.wars-nicht.de
Whole thread Raw
In response to Re: SHOW TABLES  (Peter Eisentraut <peter_e@gmx.net>)
List 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


pgsql-hackers by date:

Previous
From: Richard Huxton
Date:
Subject: Re: SHOW TABLES
Next
From: Kaare Rasmussen
Date:
Subject: Listen/Notify in 9.0