---

SELECT
    schemaname AS schema_name,
    viewname AS object_name,
    'view' AS object_type,
    definition
FROM pg_views
WHERE (
        definition ILIKE '%contribution_ss%'
        OR definition ILIKE '%contribution_sr%'
      )
   OR definition ILIKE '%contribution_contract%'

UNION ALL

SELECT
    schemaname AS schema_name,
    matviewname AS object_name,
    'materialized view' AS object_type,
    definition
FROM pg_matviews
WHERE (
        definition ILIKE '%contribution_ss%'
        OR definition ILIKE '%contribution_sr%'
      )
   OR definition ILIKE '%contribution_contract%'

ORDER BY schema_name, object_name;