Postgres - List tables

Using psql

\dt

# \dt
             List of relations
 Schema |     Name      | Type  |  Owner
--------+---------------+-------+----------
 public | actor         | table | postgres
 public | address       | table | postgres
 public | category      | table | postgres
 ....

Using pg_catalog schema

SELECT
   *
FROM
   pg_catalog.pg_tables
WHERE
   schemaname != 'pg_catalog'
AND schemaname != 'information_schema';

Reference:

• http://www.postgresqltutorial.com/postgresql-show-tables/