Switch databases in PostgreSQL with `\connect`

With good ol’ MySQL I was used to switch database with use <db_name>;. Postgres has a different way to switch databases, you do so using one of its meta-commands. Once you are in the Postgres terminal, you enter using the psql command, you can switch databases with \connect <db_name> command or with the shorter \c <db_name>.

postgres=# \c myproject
You are now connected to database "myproject" as user "postgres".
myproject=#
postgres=# \connect myproject
You are now connected to database "myproject" as user "postgres".
myproject=#

In order to list the available databases you use the \l or \list meta-command.

See Also

6 Non-Programming Books for Programmers