Change to a different database

When you are connected to a database in a session, you can use the SET CATALOG command to change to a different database. For example:

MYDB.SCHEMA(USER)=> SET CATALOG sales;
SET CATALOG
SALES.SCHEMA(USER)=>

The SET CATALOG command cannot be used inside a transaction block or the body of a stored procedure. The SET CATALOG keeps the session (unlike the \c nzsql option that closes and opens a session to the new database).