---

SELECT DISTINCT
    n.nspname AS schema_name,
    c.relname AS object_name,
    CASE c.relkind
        WHEN 'v' THEN 'view'
        WHEN 'm' THEN 'materialized view'
        ELSE c.relkind::text
    END AS object_type,
    a.attname AS column_name
FROM pg_depend d
JOIN pg_rewrite r
    ON r.oid = d.objid
JOIN pg_class c
    ON c.oid = r.ev_class
JOIN pg_namespace n
    ON n.oid = c.relnamespace
JOIN pg_attribute a
    ON a.attrelid = d.refobjid
   AND a.attnum = d.refobjsubid
WHERE d.refclassid = 'pg_class'::regclass
  AND d.classid = 'pg_rewrite'::regclass
  AND d.refobjid = 'mail.members_group_recipients'::regclass
  AND a.attname IN ('to_portal', 'chat_idx')
ORDER BY n.nspname, c.relname, a.attname;