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.
- Switch database
\connect to switch the database.
postgres=# \c user psql (8.4.20) You are now connected to database "user".