\set ECHO_HIDDEN on

\set ECHO_HIDDEN on

postgres=# \c demo
You are now connected to database "demo" as user "postgres".
demo=# \set ECHO_HIDDEN on
demo=# \dt+
********* QUERY **********
SELECT n.nspname as "Schema",
  c.relname as "Name",
  CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm' THEN 'materialized view' 
  WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence'
  WHEN 's' THEN 'special' WHEN 'f' THEN 'foreign table' WHEN 'p' THEN 'partitioned table' 
  WHEN 'I' THEN 'partitioned index' END as "Type",
  pg_catalog.pg_get_userbyid(c.relowner) as "Owner",
  pg_catalog.pg_size_pretty(pg_catalog.pg_table_size(c.oid)) as "Size",
  pg_catalog.obj_description(c.oid, 'pg_class') as "Description"
FROM pg_catalog.pg_class c
     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind IN ('r','p','')
      AND n.nspname <> 'pg_catalog'
      AND n.nspname <> 'information_schema'
      AND n.nspname !~ '^pg_toast'
  AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY 1,2;
**************************

                                         List of relations
  Schema  |            Name            | Type  |  Owner   |    Size    |        Description        
----------+----------------------------+-------+----------+------------+---------------------------
 bookings | aircrafts_data             | table | postgres | 16 kB      | Aircrafts (internal data)
 bookings | airports_data              | table | postgres | 56 kB      | Airports (internal data)