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:
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!