\dt
# \dtList of relationsSchema | Name | Type | Owner--------+---------------+-------+----------public | actor | table | postgrespublic | address | table | postgrespublic | category | table | postgres....
SELECT*FROMpg_catalog.pg_tablesWHEREschemaname != 'pg_catalog'AND schemaname != 'information_schema';
Reference: