How to switch databases in psql?

postgresql psql
Blankman picture Blankman · Oct 16, 2010 · Viewed 698.3k times · Source

In MySQL, I used use database_name;

What's the psql equivalent?

Answer

Will Hartung picture Will Hartung · Oct 16, 2010

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

\connect DBNAME

or in short:

\c DBNAME

Related questions

PostgreSQL "DESCRIBE TABLE"

How do you perform the equivalent of Oracle's DESCRIBE TABLE in PostgreSQL (using the psql command)?

Read More
Run a PostgreSQL .sql file using command line arguments

I have some .sql files with thousands of INSERT statements in them and need to run these inserts on my PostgreSQL database in order to add them to a table. The files are that large that it is impossible to …

Read More
How to exit from PostgreSQL command line utility: psql

What command or short key can I use to exit the PostgreSQL command line utility psql?

Read More