Sometimes this prepared select can come handy.
Shows all objects listed in CASE structure – without catalog objects and toast tables:
select ns.nspname as schemaname, c.relname as objectname, case relkind when 'r' then 'table' when 'i' then 'index' when 'S' then 'sequence' when 'v' then 'view' when 'c' then 'composite type' when 't' then 'TOAST table' when 'm' then 'materialized view' else '?' end as objecttype from pg_class c join pg_type t on c.reltype = t.oid join pg_namespace ns on c.relnamespace = ns.oid where nspname not in ('pg_catalog', 'information_schema', 'pg_toast') order by 1,2,3