How to switch databases in psql?

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

References



Comments