Inside psql, you always have one active database, where you are “into”. By default it’s the one you connect to in the first place. When you run:

psql postgres

you’ll connect to the postgres database.

To switch database, use the \connect command, or \c:

Switch database in Postgres

Postgres will close the connection to the previous database you were connected to, and will connect to the new one you specified.


Pssst! Also check my latest YouTube video



I am writing a book on how to create a successful blog as a developer.
It will be released late February.
Signup to my newsletter to get 2/3 free chapters in your inbox in the next few weeks!