Sender: #postgres@phalanx.phalanx.net
Message-ID: <37B8A5B4.A85541A0@phalanx.net>
Date: Mon, 16 Aug 1999 23:58:44 +0000
From: Mark Dzmura <mdz@phalanx.phalanx.net>
MIME-Version: 1.0
To: "pgsql-interfaces@postgreSQL.org" <pgsql-interfaces@postgreSQL.org>
Subject: A few more JDBC meta-data questions...
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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 programatically enumerate or discover the databases in a running database??

2. Is it possible to programmaticaly enumerate or discover the tables in a database??

For the latter, I believe that I could use regular queries against postgresq's system catalogs,
but I am primarily interested in portable approaches - generic SQL and JDBC which stand
a good chance of (eventually) working with other databases.

Thanks,
Mark Dzmura

--
)))) This email routed via a wireless gateway!! ((((