SELECT 
table_schema, 
table_name,
column_name,
'VIEW' AS type,
regexp_replace(view_definition,'[\r\n]','<br>','g') AS view_definition
FROM 
information_schema.views AS v INNER JOIN information_schema.columns AS c
USING (table_schema, table_name)
WHERE table_schema NOT IN (SELECT schema_name
FROM INFORMATION_SCHEMA.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL)
AND c.data_type='xid'
UNION SELECT nspname, relname, attname,
'MATERIALIZED VIEW' AS type,
regexp_replace(pg_get_viewdef(pg_class.oid),'[\r\n]','<br>','g') AS view_definition
FROM pg_class INNER JOIN pg_namespace ON pg_class.relnamespace=pg_namespace.oid
INNER JOIN pg_attribute ON pg_class.oid=pg_attribute.attrelid INNER JOIN pg_type ON
pg_attribute.atttypid=pg_type.oid
WHERE relkind = 'm' AND attnum>=1 AND attisdropped='f' AND typname='xid'
ORDER BY table_schema, table_name, type;