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

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 (view raw or flat)
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!! ((((
>> 
>> 
>> 
>> 

pgsql-interfaces by date

Next:From: wwwmailDate: 1999-08-17 08:02:43
Subject: psql's clone in java
Previous:From: Huang KaiDate: 1999-08-17 07:51:38
Subject: psql's clone in java

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