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.

A connection has been made to the database mydb
and you can see the prompt changed to mydb-#
.
Select Database using pgAdmin
You can also select the database and open SQL Query window in pgAdmin UI.
Step 1: Select the database, by clicking on it.

Now, click on the Tools
drop down menu and click on Query Tool
.

Now, a new window appears with a connection make to the database you selected. You can run SQL queries here.

Conclusion
In this PostgreSQL Tutorial, we have learnt how to connect or select a specific database in PostgreSQL.