postgresqlpsql

How to switch databases in psql?

In MySQL, I used use database_name;

What's the psql equivalent?

Solution

  • In PostgreSQL, you can use the \connect meta-command of the client tool psql:

    \connect DBNAME

    or in short:

    \c DBNAME