PostgreSQL – SELECT Database
If you want to list all databases please use
\list
After listing all the databases we have to select a working database. In order to do this we have to type a command as :
postgres=# \c data1
Where data1 is name of database to be selected.