Consulta os objetos de banco de dados

Estrutura de banco de dados

SELECT COUNT(1) AS qtd,
       tipo
  FROM (SELECT DISTINCT table_schema AS objeto,
                        'esquemas' AS tipo
          FROM information_schema.tables
          WHERE table_schema != 'pg_catalog'
            AND table_schema != 'information_schema'
        UNION ALL
        SELECT table_schema || '.' || table_name AS objeto,
               CASE WHEN table_type = 'BASE TABLE' THEN 'tabelas'
                    WHEN table_type = 'VIEW' THEN 'views'
                    ELSE '???'
                 END AS tipo
          FROM information_schema.tables
          WHERE table_schema != 'pg_catalog'
            AND table_schema != 'information_schema'
        UNION ALL
        SELECT DISTINCT routine_schema || '.' || routine_name AS objeto,
               'funcoes' AS tipo
          FROM information_schema.routines
          WHERE routine_schema != 'pg_catalog'
            AND routine_schema != 'information_schema') a
  GROUP BY tipo