PostgreSQL: Show tables in PostgreSQL

Question

What's the equivalent to show tables (from MySQL) in PostgreSQL?

Answer 1

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.

Answer 2

Login as superuser:

sudo -u postgres psql 

You can list all databases and users by \l command, (list other commands by \?).

Now if you want to see other databases you can change user/database by \c command like \c template1, \c postgres postgres and use \d, \dt or \dS to see tables/views/etc.