PostgreSQL – SELECT Database

PostgreSQL – SELECT Database or Connect to a Database

You can have multiple databases in PostgreSQL. And to run SQL queries on a specific database, you can select the database by making a connection to the database.

Select Database using psql

To select a database or make a connection to the database, run the select/connect command as shown below.

 \c databasename

where databasename is the name of your database.