List of database in postgres

[russell]

Hi all ,

I am using postgresql7.0.1 , jbuilder3.5 and jdk1.3.
Anyways to display the list of database(not tables) using JDBC ??

Anybody have ideas ??

Thanks.

[John B. Moore]

In article <3CAD6CD0...@hdbay.com>, Russell wrote:
> I am using postgresql7.0.1 , jbuilder3.5 and jdk1.3.
> Anyways to display the list of database(not tables) using JDBC ??
>

If something like that is available it would have to be driver and
server specific. Problem is that there is no "standard Service API"
which would be used to discover this information. You could write a
JNI dll to do this and call it within your Java program. Or check and
see it that driver supports such methods.. Currently there is no
interface for "getDatabases(...)" type method..

John..

+++++++++++++++++++++++
TeamB are volunteer helpers. Please do not email replies or questions.
Post or reply only on this newsgroup. Thank you.
For Papers on DataExpress, Applets, and Web Technologies go to:
http://www.microps.com/mps/papers.html
=======================

[Daniel Schulz]

Hi,

> I am using postgresql7.0.1 , jbuilder3.5 and jdk1.3.
> Anyways to display the list of database(not tables) using JDBC ??

Well it's not really JDBC, but you can get it from the pg_database
catalog table. The datname column holds the names of the available dbs:
http://www.postgresql.org/idocs/index.php?catalog-pg-database.html

Bye,
Daniel