Re: SHOW TABLES

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