RE: [INTERFACES] a few additional JDBC points?? - Mailing list pgsql-interfaces

From Ansley, Michael
Subject RE: [INTERFACES] a few additional JDBC points??
Date
Msg-id 1BF7C7482189D211B03F00805F8527F70ED0EC@S-NATH-EXCH2
Whole thread Raw
List pgsql-interfaces
Why can't you connect to template1 (all (most) servers have one, right?),
and then select * from pg_database, or select * from pg_class where rel_kind
= 'r' .

>> 
>> Peter,
>> 
>> Thanks for your incisive replies to my earlier query.. I 
>> still have two questions.
>> (I wouldn't ask them if I was able to find the answers 
>> elsewhere, but I haven't
>> found them in the JDBC 1.2 or 2.0 specs, or the 2 books in 
>> my possession which
>> give some coverage to JDBC...)
>> 
>> From JDBC,
>> 
>> 1. Is it possible to enumerate or discover the databases in 
>> a running database??
>> 
>> 2. Is it possible to enumerate or discover the tables in a database??
>> 
>> Thanks,
>> Mark Dzmura
>> 
>> --
>> )))) This email routed via a wireless gateway!! ((((
>> 
>> 
>> 
>> 


pgsql-interfaces by date:

Previous
From: "Huang Kai"
Date:
Subject: psql's clone in java
Next
From: "wwwmail"
Date:
Subject: psql's clone in java