How to show all available tables in PostgreSQL?

1. Using SQL Query

To show the list of tables with the corresponding schema name, run this statement:

SELECT * FROM information_schema.tables;

or in a particular schema:

SELECT * FROM information_schema.tables WHERE table_schema = 'schema_name';

2. Using psql

To list all tables:

  • In all schemas: \dt *.*
  • In a particular schema: \dt schema_name.*

3. Using TablePlus

In TablePlus, you can either use the query editor to run the statements above or see the list of the tables in the current schema on the left sidebar of the workspace.

To switch and see tables from another schema, navigate to the dropdown schema list at the bottom of the left sidebar and select the schema.

tables-list-in-TablePlus

Need a good GUI tool for PostgreSQL? Check out TablePlus. It’s native, beautiful, and available for free.

Download TablePlus for Mac.

Not on Mac? Download TablePlus for Windows.

TablePlus GUI Tool PostgreSQL