How to switch databases in psql?

postgresql psql

In PostgreSQL, you can use the \connect meta-command of the client tool psql:

\connect DBNAME

or in short:

\c DBNAME

postgresql psql

You can connect to a database with \c <database> or \connect <database>.

postgresql psql

At the PSQL prompt, you can do:

\connect (or \c) dbname

CodeHunter