WITH derived_tables AS (
SELECT 
c.oid,
n.nspname AS schema_name,
c.relname AS table_name,
CASE WHEN c.relkind='v' THEN 'VIEW'
WHEN c.relkind='m' THEN 'MATERIALIZED VIEW' END AS table_type,
at.attname AS column_name,
regexp_replace(pg_get_viewdef(c.oid),'[\r\n]','<br>','g') AS view_src
FROM pg_attribute at INNER JOIN pg_class c ON at.attrelid=c.oid
INNER JOIN pg_namespace AS n ON n.oid=c.relnamespace
INNER JOIN pg_authid AS a ON n.nspowner=a.oid
WHERE (nspname='public' OR rolname<>'postgres')
AND c.relkind IN ('v','m')
AND at.attisdropped='f'
AND at.attnum>0
)
SELECT schema_name, table_name, table_type, column_name, view_src
FROM derived_tables
WHERE column_name='?column?'
ORDER BY schema_name, table_name;