PostgreSQL switch database 2017-10-17 07:36

In PosgreSQL there are several ways to switch database.

  • Before connecting

Before connecting to server you can use following command to appoint the database you want to connect.

psql <database_name>
  • Switch database

Use \c or \connect to switch the database.

postgres=# \c user
psql (8.4.20)
You are now connected to database "user".