Skip site navigation (1) Skip section navigation (2)

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

From: Michael Wood <esiotrot(at)gmail(dot)com>
To: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
Cc: Christopher Frank <c(dot)frank(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org, pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [NOVICE] Bug - DatabaseMetaData.getCatalogs() was [Novice] Can't get list of databases with \list
Date: 2009-11-03 18:29:08
Message-ID: 5a8aa6680911031029q1d8e592fj90f47f1b25e62bf8@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbcpgsql-novice
2009/11/3 Richard Broersma <richard(dot)broersma(at)gmail(dot)com>:
> On Mon, Nov 2, 2009 at 1:05 PM, Christopher Frank <c(dot)frank(at)gmail(dot)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(at)gmail(dot)com>

In response to

Responses

pgsql-novice by date

Next:From: Lars GustafssonDate: 2009-11-03 18:30:32
Subject: Re: corrupt db
Previous:From: Lonni J FriedmanDate: 2009-11-03 18:24:39
Subject: Re: corrupt db

pgsql-jdbc by date

Next:From: Richard BroersmaDate: 2009-11-03 18:39:54
Subject: Re: [NOVICE] Bug - DatabaseMetaData.getCatalogs() was [Novice] Can't get list of databases with \list
Previous:From: Kris JurkaDate: 2009-11-03 18:21:50
Subject: Re: Help with prepared statment for crosstab

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group