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
Comments
Post a Comment