In this post, we will see how to switch databases in PostgreSQL (psql) command-line interface.

Connect to a specific database

\c database_name

For example, the following command connects to the "employees" database:

mydb=# \c employees
You are now connected to database "employees" as user "postgres".
employees=#

To quit the psql shell

\q