How to switch databases in psql?
In PostgreSQL, you can use the \connect
meta-command of the client tool psql:
\connect DBNAME
or in short:
\c DBNAME
At the PSQL prompt, you can do:
\connect (or \c) dbname
You can connect to a database with \c <database>
or \connect <database>
.