Re: [ADMIN] [GENERAL] Use, Set Catalog and JDBC questions

2013-02-25 Thread Adrian Klaver
On 02/25/2013 11:21 AM, Frank Cavaliero wrote: Hi Adrian, Thanks a lot!I will certainly look into the multiple datasources as an option. Just remember, as John pointed out, a MySQL database and a Postgres database are not equivalent. You will not be able to do cross database operations(

Re: [ADMIN] [GENERAL] Use, Set Catalog and JDBC questions

2013-02-25 Thread Frank Cavaliero
Hi Adrian, Thanks a lot!I will certainly look into the multiple datasources as an option. -Frank From: Adrian Klaver To: Frank Cavaliero/Boston/IBM@IBMUS Cc: pgsql-admin@postgresql.org, pgsql-gene...@postgresql.org Date: 02/25/2013 02:16 PM Subject: Re: [GENERAL] Use, Set Catalog a

Re: [ADMIN] [GENERAL] Use, Set Catalog and JDBC questions

2013-02-25 Thread k...@rice.edu
On Mon, Feb 25, 2013 at 01:57:11PM -0500, Frank Cavaliero wrote: > 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 databa

Re: [ADMIN] [GENERAL] Use, Set Catalog and JDBC questions

2013-02-25 Thread Adrian Klaver
On 02/25/2013 10:57 AM, Frank Cavaliero wrote: 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

Re: [ADMIN] [GENERAL] Use, Set Catalog and JDBC questions

2013-02-25 Thread Frank Cavaliero
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 Postgre

Re: [ADMIN] [GENERAL] Use, Set Catalog and JDBC questions

2013-02-25 Thread Adrian Klaver
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 d