Re: Bug - DatabaseMetaData.getCatalogs() was [Novice] Can't get list of databases with \list - Mailing list pgsql-novice

From Michael Wood
Subject Re: Bug - DatabaseMetaData.getCatalogs() was [Novice] Can't get list of databases with \list
Date
Msg-id 5a8aa6680911031029q1d8e592fj90f47f1b25e62bf8@mail.gmail.com
Whole thread Raw
In response to Bug - DatabaseMetaData.getCatalogs() was [Novice] Can't get list of databases with \list  (Richard Broersma <richard.broersma@gmail.com>)
Responses Re: Bug - DatabaseMetaData.getCatalogs() was [Novice] Can't get list of databases with \list  (Richard Broersma <richard.broersma@gmail.com>)
List pgsql-novice
2009/11/3 Richard Broersma <richard.broersma@gmail.com>:
> On Mon, Nov 2, 2009 at 1:05 PM, Christopher Frank <c.frank@gmail.com> wrote:
>
>>> > As for JDBC, there may be something that gives equivalent information,
>>> > but I
>>> > couldn't find it.
>>>
>>> http://java.sun.com/javase/6/docs/api/java/sql/DatabaseMetaData.html
>>>
>>> getCatalogs()
>
>> I had tried that but it only returned one database, the database to which I
>> was already connected. There should have been 3 others.
>
> I verified that the DatabaseMetaData.getCatalogs() only returns a
> ResultSet with the currently connect database rather than all of the
> databases in the PostgreSQL cluster.

What does it do when you have multiple schemas (schemata?) in the database?

--
Michael Wood <esiotrot@gmail.com>

pgsql-novice by date:

Previous
From: Lonni J Friedman
Date:
Subject: Re: corrupt db
Next
From: Lars Gustafsson
Date:
Subject: Re: corrupt db