Re: Use, Set Catalog and JDBC questions - Mailing list pgsql-general

From Frank Cavaliero
Subject Re: Use, Set Catalog and JDBC questions
Date
Msg-id OF634F0290.B126088B-ON85257B1D.00681DCA-85257B1D.0068631C@us.ibm.com
Whole thread Raw
In response to Re: Use, Set Catalog and JDBC questions  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: Use, Set Catalog and JDBC questions  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: [ADMIN] Use, Set Catalog and JDBC questions  ("ktm@rice.edu" <ktm@rice.edu>)
List pgsql-general
Hi Adrian,

Thanks for the response.   The situation is more like the following:

Using the JDBC driver, I connect to database TEST1 and immediately, without having to pass username credentials again, I want to use database TEST2.   In MySQL, you can simply run:  use TEST2.  Wondering if PostgreSQL has something similar.

Thanks,
Frank







From:Adrian Klaver <adrian.klaver@gmail.com>
To:Frank Cavaliero/Boston/IBM@IBMUS
Cc:pgsql-general@postgresql.org, pgsql-admin@postgresql.org
Date:02/25/2013 01:48 PM
Subject:Re: [GENERAL] Use, Set Catalog and JDBC questions





On 02/25/2013 10:22 AM, Frank Cavaliero wrote:
> 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?

Not sure if this will do what want?:
http://jdbc.postgresql.org/documentation/91/datasource.html#ds-intro
>
>
> Thanks,
> Frank
>
> /Database Administrator/
>


--
Adrian Klaver
adrian.klaver@gmail.com



pgsql-general by date:

Previous
From: Stefan Keller
Date:
Subject: Re: Reading an OUT parameter out of a function call
Next
From: Frank Cavaliero
Date:
Subject: Re: Use, Set Catalog and JDBC questions