How to switch databases in psql?

Question

In MySQL, I used `use database_name;` What's the `psql` equivalent?

Accepted Answer

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

```
\connect DBNAME
```

or in short:

```
\c DBNAME
```

Solution