Perhaps searching based on a name instead of a code

Copy SQL

WITH user_defined_derived_tables AS (SELECT 
views.table_schema, 
views.table_name, 
views.view_definition,
'VIEW' AS table_type
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, definition, 'MATERIALIZED VIEW' AS table_type
FROM pg_catalog.pg_matviews)
SELECT
table_schema,
table_name,
regexp_replace(
regexp_replace(view_definition,'((?<!(LEADING|TRAILING|BOTH)[[:space:]])FROM|ORDER BY|WHERE|GROUP BY|SELECT|HAVING|UNION|EXCEPT|INTERSECT|LIMIT|FETCH FIRST)','<br><b>\1</b>','g'),
'(LEFT JOIN|RIGHT JOIN|CROSS JOIN|FULL JOIN)','<font color=red>\1</font>','g') AS def,
table_type
FROM user_defined_derived_tables
WHERE view_definition~*'(?<=WHERE.*)''[[:alpha:]]{6,}'''
ORDER BY table_schema, table_name;