Re: Use, Set Catalog and JDBC questions

Hi John,

Thanks for the response. I will look into that as an option.

Thanks,
Frank

From:
John R Pierce <pierce(at)hogranch(dot)com>
To:
pgsql-general(at)postgresql(dot)org
Date:
02/25/2013 01:33 PM
Subject:
Re: [GENERAL] Use, Set Catalog and JDBC questions
Sent by:
pgsql-general-owner(at)postgresql(dot)org

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