Names of the columns of derived tables that have been given by the system

WITH columns AS (SELECT nspname AS table_schema, relname AS table_name, 
CASE WHEN relkind='m' THEN 'MATERIALIZED VIEW' ELSE 'VIEW' END AS table_type, attname AS column_name,
pg_get_viewdef(pg_class.oid) AS viewdef
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
WHERE relkind IN ( 'm','v') AND attnum>=1 AND 
nspname NOT IN (SELECT schema_name
FROM INFORMATION_SCHEMA.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL))
SELECT table_schema, table_name, table_type, column_name, viewdef
FROM columns
WHERE (lower(column_name) IN ('min','max','sum','avg', 'count', 'string_agg', 'array_agg', 'json_agg')
AND viewdef~*'(min|max|sum|avg|count|string_agg|array_agg|json_agg)[(]')
OR lower(column_name) IN ('?column?')
ORDER BY table_schema, table_name, column_name;