Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-admin-owner+M40758=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1UA2sM-0007wM-5O
	for pgsql-admin@arkaria.postgresql.org; Mon, 25 Feb 2013 18:34:10 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-admin-owner+M40758=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1UA2sL-0000up-Bg
	for pgsql-admin@arkaria.postgresql.org; Mon, 25 Feb 2013 18:34:09 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <adrian.klaver@gmail.com>)
	id 1UA2sK-0000uf-GV; Mon, 25 Feb 2013 18:34:08 +0000
Received: from mail-da0-f51.google.com ([209.85.210.51])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <adrian.klaver@gmail.com>)
	id 1UA2sI-0004aX-84; Mon, 25 Feb 2013 18:34:07 +0000
Received: by mail-da0-f51.google.com with SMTP id n15so1589618dad.10
	for <multiple recipients>; Mon, 25 Feb 2013 10:34:05 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
	h=x-received:message-id:date:from:user-agent:mime-version:to:cc
	:subject:references:in-reply-to:content-type
	:content-transfer-encoding;
	bh=izCO5qFsL+Y4hDvBK9M3zfr9jCHWubIjpxgVqzdMDUg=;
	b=HDDOmaXl+ItPZ+Ry7utRtILF3OvjkvJ3u8wIJYnKkrqHT+0EsBDHopyNYzekM00cmD
	n/RB3VzQfq8VGCtIeEYyewYgoPzwLtQig3BX/D3I1bPJ+ijTJa7n26g4EDK8X6vma6hT
	XG1O4KO6Okfn28iCLY1qI9hMJRmpjtr297LX8KsU+a101wuK1S8MESkIukOoJ2lN0pan
	lv27dfYM5s3+2nuoQtr+rQRLh/U4tJSjvT+6s22HM3UHP2b3d75md1pZFgfNwYklBkgW
	sjPQZRDZbfLvbUHC/SrNxM8g0p6/yGEk2UQjey6NHGDlUsr94Q1Z9bOQQrtwdpwAns/E
	b84A==
X-Received: by 10.68.211.103 with SMTP id nb7mr19413815pbc.140.1361817245083;
	Mon, 25 Feb 2013 10:34:05 -0800 (PST)
Received: from [192.168.0.153] (c-24-17-179-185.hsd1.wa.comcast.net.
	[24.17.179.185]) by mx.google.com with ESMTPS id
	qb10sm13491297pbb.43.2013.02.25.10.34.03
	(version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
	Mon, 25 Feb 2013 10:34:04 -0800 (PST)
Message-ID: <512BAE9A.2000401@gmail.com>
Date: Mon, 25 Feb 2013 10:34:02 -0800
From: Adrian Klaver <adrian.klaver@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux i686;
	rv:17.0) Gecko/20130215 Thunderbird/17.0.3
MIME-Version: 1.0
To: Frank Cavaliero <fcavalie@us.ibm.com>
CC: pgsql-general@postgresql.org, pgsql-admin@postgresql.org
Subject: Re: [GENERAL] Use, Set Catalog and JDBC questions
References: 
 <OF452CD15F.978F2C6E-ON85257B1D.0063F9C0-85257B1D.00653F7F@us.ibm.com>
In-Reply-To: 
 <OF452CD15F.978F2C6E-ON85257B1D.0063F9C0-85257B1D.00653F7F@us.ibm.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin