All objects in database

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...