Postgresql – How to switch databases in psql

postgresqlpsql

In MySQL, I used use database_name;

What's the psql equivalent?

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

\connect DBNAME

or in short:

\c DBNAME

Try this (in the psql command-line tool):

\d+ tablename

See the manual for more info.

From the psql command line interface,

First, choose your database

\c database_name

Then, this shows all tables in the current schema:

\dt

Programmatically (or from the psql interface too, of course):

SELECT * FROM pg_catalog.pg_tables;

The system tables live in the pg_catalog database.