How to connect to another database in psql

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