Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-general-owner+M195365=pgsql-general-arkari@postgresql.org>)
	id 1UA2nj-0007ED-6q for pgsql-general@arkaria.postgresql.org;
	Mon, 25 Feb 2013 18:29:23 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-general-owner+M195365=pgsql-general-arkari@postgresql.org>)
	id 1UA2ni-0007GS-9g for pgsql-general@arkaria.postgresql.org;
	Mon, 25 Feb 2013 18:29:22 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <pierce@hogranch.com>) id 1UA2ng-0007FE-Ib
	for pgsql-general@postgresql.org; Mon, 25 Feb 2013 18:29:20 +0000
Received: from hogranch.com ([75.101.82.47])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <pierce@hogranch.com>) id 1UA2nd-0008N1-B1
	for pgsql-general@postgresql.org; Mon, 25 Feb 2013 18:29:20 +0000
Received: from [192.168.0.2] (porker [192.168.0.2])
	by hogranch.com (8.11.6/8.11.6) with ESMTP id r1PIT7921835
	for <pgsql-general@postgresql.org>; Mon, 25 Feb 2013 10:29:07 -0800
Message-ID: <512BAD6F.6020800@hogranch.com>
Date: Mon, 25 Feb 2013 10:29:03 -0800
From: John R Pierce <pierce@hogranch.com>
User-Agent: Mozilla/5.0 (Windows NT 6.2; WOW64;
	rv:17.0) Gecko/20130215 Thunderbird/17.0.3
MIME-Version: 1.0
To: pgsql-general@postgresql.org
Subject: Re: 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: multipart/alternative;
	boundary="------------060701090806040903090209"
X-HawgScanner-Information: Please contact the ISP for more information
X-HawgScanner: Found to be clean
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-general>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-general.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@postgresql.org>
List-Post: <mailto:pgsql-general@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-general>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
X-Mailing-List: pgsql-general
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

This is a multi-part message in MIME format.
--------------060701090806040903090209
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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

no, there isn't.    you have to connect to the database.     mysql's 
databases are in many ways equivalent to postgres'  'schemas' within a 
single database (you can move between schemas with SET SEARCH_PATH=...).

-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast


--------------060701090806040903090209
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix">On 2/25/2013 10:22 AM, Frank Cavaliero
      wrote:<br>
    </div>
    <blockquote
cite="mid:OF452CD15F.978F2C6E-ON85257B1D.0063F9C0-85257B1D.00653F7F@us.ibm.com"
      type="cite"><font size="2" face="sans-serif">1. &nbsp;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 ? &nbsp; In Java, we are using set catalog to do
        this
        in MySQL.</font>
      <br>
    </blockquote>
    <br>
    no, there isn't.&nbsp;&nbsp;&nbsp; you have to connect to the database.&nbsp;&nbsp;&nbsp;&nbsp; mysql's
    databases are in many ways equivalent to postgres'&nbsp; 'schemas' within
    a single database (you can move between schemas with SET
    SEARCH_PATH=...).<br>
    <br>
    <pre class="moz-signature" cols="72">-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast</pre>
  </body>
</html>

--------------060701090806040903090209--