Re: Use, Set Catalog and JDBC questions

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