---

SELECT
    schemaname,
    viewname
FROM pg_views
WHERE definition ILIKE '%members_group_recipients%'
  AND (
      definition ILIKE '%to_portal%'
      OR definition ILIKE '%chat_idx%'
  )
ORDER BY schemaname, viewname;



SELECT
    schemaname,
    matviewname
FROM pg_matviews
WHERE definition ILIKE '%members_group_recipients%'
  AND (
      definition ILIKE '%to_portal%'
      OR definition ILIKE '%chat_idx%'
  )
ORDER BY schemaname, matviewname;





BEGIN;

ALTER TABLE mail.members_group_recipients
    DROP COLUMN to_portal;

ALTER TABLE mail.members_group_recipients
    DROP COLUMN chat_idx;

ROLLBACK;