Thread: Listing Database

Hello,

I am starting out with the PostgreSQL JDBC and I was wondering how to
get a list of the databases. I know from the psql command line, \l will
do it. But how about within a Java app?

Thanks,
Steve.

Steven Bell wrote:
> I am starting out with the PostgreSQL JDBC and I was wondering how to
> get a list of the databases. I know from the psql command line, \l
> will do it. But how about within a Java app?

Just a guess, but you might connect to a database that you know is there
(template1?) and call DatabaseMetaData.getCatalogs().  Does that work?

--
www.designacourse.com
The Easiest Way to Train Anyone... Anywhere.

Chris Smith - Lead Software Developer/Technical Trainer
MindIQ Corporation

what if you just execute the query "select datname from pg_database" in a Statement and iterate the ResultSet?


On Fri, 2004-07-02 at 15:21, Steven Bell wrote:

Hello,

I am starting out with the PostgreSQL JDBC and I was wondering how to 
get a list of the databases. I know from the psql command line, \l will 
do it. But how about within a Java app?

Thanks,
Steve.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
              http://www.postgresql.org/docs/faqs/FAQ.html