Postgres Pro
Downloads
Home   >   mailing lists

Use, Set Catalog and JDBC questions - Mailing list pgsql-admin

From Frank Cavaliero
Subject Use, Set Catalog and JDBC questions
Date
Msg-id OF452CD15F.978F2C6E-ON85257B1D.0063F9C0-85257B1D.00653F7F@us.ibm.com
Whole thread Raw
Responses Re: [GENERAL] Use, Set Catalog and JDBC questions  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-admin
Tree view
Hi,

I have an application that requires to connect to each database available in PostgreSQL.  I have the following questions:


1.  Is there a USE DATABASE command or something of the sort (similar to MySQL) that allows you to quickly connect to a database without having to reconnect using the username,password and database again ?   In Java, we are using set catalog to do this in MySQL.

2.  Based on #1 above, would the latest JDBC driver support the ability to create this type of connection?


Thanks,
Frank

Database Administrator

pgsql-admin by date:

Previous
From: John Rouillard
Date:
Subject: Re: logging full queries separately
Next
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Use, Set Catalog and JDBC questions