RE: [INTERFACES] a few additional JDBC points??

From: "Ansley, Michael" <Michael(dot)Ansley(at)intec(dot)co(dot)za>
To: "'Mark Dzmura'" <mdz(at)phalanx(dot)phalanx(dot)net>, pgsql-interfaces(at)postgreSQL(dot)org
Subject: RE: [INTERFACES] a few additional JDBC points??
Date: 1999-08-17 07:53:43
Message-ID: 1BF7C7482189D211B03F00805F8527F70ED0EC@S-NATH-EXCH2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!! ((((
>>
>>
>>
>>

Browse pgsql-interfaces by date

  From Date Subject
Next Message wwwmail 1999-08-17 08:02:43 psql's clone in java
Previous Message Huang Kai 1999-08-17 07:51:38 psql's clone in java