WITH all_columns AS (SELECT table_schema, table_name, column_name
FROM INFORMATION_SCHEMA.columns
WHERE (table_schema, table_name) IN (SELECT table_schema, table_name
FROM INFORMATION_SCHEMA.tables WHERE table_type='BASE TABLE') 
AND 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 is_generated='NEVER'),
generated_columns AS (SELECT table_schema, table_name, column_name, generation_expression
FROM INFORMATION_SCHEMA.columns
WHERE (table_schema, table_name) IN (SELECT table_schema, table_name
FROM INFORMATION_SCHEMA.tables WHERE table_type='BASE TABLE') 
AND 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 is_generated='ALWAYS'),
referred_columns AS (
SELECT a.table_schema, a.table_name, a.column_name, g.generation_expression
FROM all_columns AS a INNER JOIN generated_columns AS g
ON a.table_schema=g.table_schema AND a.table_name=g.table_name
WHERE g.generation_expression LIKE '%' || a.column_name || '%')
SELECT table_schema, table_name, column_name, generation_expression
FROM generated_columns AS ge
WHERE NOT EXISTS (SELECT 1
FROM referred_columns AS r
WHERE r.table_schema=ge.table_schema
AND r.table_name=ge.table_name
AND r.generation_expression=ge.generation_expression)
ORDER BY table_schema, table_name;