\dtv [ PATTERN ]

The \dtv [ PATTERN ] meta-command lists all tables and views, returning the schema, table or view name, kind (table of view), and owner.

vmartdb=> \dtv
                     List of tables
    Schema    |         Name          | Kind  |  Owner
--------------+-----------------------+-------+---------
 online_sales | call_center_dimension | table | release
 online_sales | online_page_dimension | table | release
 online_sales | online_sales_fact     | table | release
 public       | customer_dimension    | table | release
 public       | date_dimension        | table | release
 public       | employee_dimension    | table | release
 public       | inventory_fact        | table | release
 public       | product_dimension     | table | release
 public       | promotion_dimension   | table | release
 public       | shipping_dimension    | table | release
 public       | vendor_dimension      | table | release
 public       | warehouse_dimension   | table | release
 store        | store_dimension       | table | release
 store        | store_orders_fact     | table | release
 store        | store_sales_fact      | table | release
(15 rows)