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?
Thanks,
Frank
Database Administrator