Use, Set Catalog and JDBC questions

From: Frank Cavaliero <fcavalie(at)us(dot)ibm(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Use, Set Catalog and JDBC questions
Date: 2013-02-25 18:22:54
Message-ID: OF452CD15F.978F2C6E-ON85257B1D.0063F9C0-85257B1D.00653F7F@us.ibm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John R Pierce 2013-02-25 18:29:03 Re: Use, Set Catalog and JDBC questions
Previous Message John Rouillard 2013-02-25 14:59:38 Re: logging full queries separately

Browse pgsql-general by date

  From Date Subject
Next Message Russell Keane 2013-02-25 18:27:23 Re: Reading an OUT parameter out of a function call
Previous Message Adrian Klaver 2013-02-25 17:37:41 Re: Reading an OUT parameter out of a function call