SELECT
table_schema,
table_name,
type,
regexp_replace(view_definition,'[\r\n]','
','g') AS view_definition
FROM (SELECT 
views.table_schema, 
views.table_name, 
'VIEW' AS type,
views.view_definition
FROM 
information_schema.views
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)
UNION SELECT schemaname, matviewname, 'MATERIALIZED VIEW' AS type, regexp_replace(definition,'[\r\n]','
','g') AS definition
FROM pg_catalog.pg_matviews) AS foo
WHERE view_definition ~*'[[:space:]](foo|bar|foobar|baz)([[:space:]]|[.]|$)'
ORDER BY table_schema, table_name;