OS Command Prompt

You can select your database from the command prompt itself at the time when you login to your database. Following is a simple example −

psql -h localhost -p 5432 -U postgress testdb

Password for user postgress: ****

psql (9.2.4)

Type "help" for help.

You are now connected to database "testdb" as user "postgres".

testdb=# 

You are now logged into PostgreSQL testdb and ready to execute your commands inside testdb. To exit from the database, you can use the command \q.