SELECT schema, regexp_replace(suspected_name, '([õäöüÕÄÖÜ])', E'<b>\\1</b>', 'g') AS suspected_name, container, type
FROM (
SELECT schema_name AS schema, schema_name AS suspected_name, catalog_name AS container, 'SCHEMA' AS type
FROM information_schema.schemata
WHERE schema_name~'[õäöüÕÄÖÜ]'
UNION SELECT table_schema AS schema, table_name AS suspected_name, table_schema AS container, table_type AS type
FROM information_schema.tables
WHERE table_type='VIEW' AND table_name~'[õäöüÕÄÖÜ]'
UNION SELECT table_schema, column_name, table_name, 'VIEW COLUMN' AS type
FROM information_schema.columns
WHERE (table_schema, table_name) IN (SELECT table_schema, table_name
FROM INFORMATION_SCHEMA.tables WHERE table_type='VIEW') AND column_name~'[õäöüÕÄÖÜ]'
UNION SELECT specific_schema, routine_name, specific_schema, 'ROUTINE' AS type
FROM information_schema.routines
WHERE routine_name~'[õäöüÕÄÖÜ]'
UNION SELECT specific_schema, parameter_name, specific_name, 'PARAMETER' AS type
FROM information_schema.parameters
WHERE parameter_name~'[õäöüÕÄÖÜ]'
UNION SELECT nspname, relname, nspname, 'MATERIALIZED VIEW' AS type
FROM pg_class INNER JOIN pg_namespace ON pg_class.relnamespace=pg_namespace.oid
WHERE relkind = 'm'
AND relname~'[õäöüÕÄÖÜ]'
UNION SELECT nspname, attname, relname, 'COLUMN' AS type
FROM pg_class INNER JOIN pg_namespace ON pg_class.relnamespace=pg_namespace.oid
LEFT JOIN pg_attribute ON pg_class.oid=pg_attribute.attrelid
WHERE relkind = 'm' AND attnum>=1 AND attname~'[õäöüÕÄÖÜ]' ) AS foo
ORDER BY type, schema, suspected_name;