pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mark Dzmura <mdz@phalanx.phalanx.net>
To: pgsql-interfaces@postgreSQL.org <pgsql-interfaces@postgreSQL.org>
Subject: A few more JDBC meta-data questions...
Date: Mon, 16 Aug 1999 23:58:44 +0000
Message-ID: <37B8A5B4.A85541A0@phalanx.net> (raw)

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!! ((((






view thread (5+ messages)  latest in thread

Message-ID: <37B8A5B4.A85541A0@phalanx.net>
Permalink:  ../37B8A5B4.A85541A0@phalanx.net/
Also on:    postgresql.org/message-id/37B8A5B4.A85541A0@phalanx.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: mdz@phalanx.phalanx.net
  Subject: Re: A few more JDBC meta-data questions...
  In-Reply-To: <37B8A5B4.A85541A0@phalanx.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox