\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)