How to connect to another database in psql Posted on
If you are familiar with MySQL, you might have been looking for a use database_name; equivalent when accessing your database from the PostgreSQL shell.
Use the following command to switch to another database:
\c my_database_name