WITH table_check AS (SELECT ccu.table_schema, ccu.table_name, t.table_type, ccu.column_name, ccu.constraint_schema, ccu.constraint_name, cc.check_clause
FROM INFORMATION_SCHEMA.constraint_column_usage AS ccu INNER JOIN INFORMATION_SCHEMA.check_constraints AS cc
USING (constraint_schema, constraint_name)
INNER JOIN INFORMATION_SCHEMA.tables AS t USING (table_schema, table_name)
WHERE cc.check_clause~*'^.+=.*ANY.*[(].*ARRAY[[].+[])].*$' 
AND cc.check_clause!~*'[[:space:]]OR[[:space:]]' 
AND t.table_type IN ('BASE TABLE', 'FOREIGN')
AND ccu.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)),

domain_check AS (SELECT cdu.table_schema, cdu.table_name, t.table_type, cdu.column_name, dc.constraint_schema, dc.constraint_name, cc.check_clause
FROM ((INFORMATION_SCHEMA.column_domain_usage AS cdu INNER JOIN
INFORMATION_SCHEMA.tables AS t USING (table_schema, table_name)) INNER JOIN INFORMATION_SCHEMA.domain_constraints AS dc
USING (domain_schema, domain_name)) INNER JOIN INFORMATION_SCHEMA.check_constraints AS cc
USING (constraint_catalog, constraint_schema, constraint_name)
WHERE t.table_type IN ('BASE TABLE', 'FOREIGN') 
AND cc.check_clause~*'^.+=.*ANY.*[(].*ARRAY[[].+[])].*$' 
AND cc.check_clause!~*'[[:space:]]OR[[:space:]]' 
AND cdu.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)),

enum_types AS (SELECT nspname AS type_schema, typname AS type_name, typtype
FROM pg_catalog.pg_type t INNER JOIN pg_catalog.pg_namespace n ON t.typnamespace=n.oid
WHERE typtype='e' 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)),

enum_cols AS (SELECT table_schema, table_name, table_type, column_name, data_type,udt_schema, udt_name
FROM INFORMATION_SCHEMA.columns INNER JOIN INFORMATION_SCHEMA.tables USING (table_schema, table_name)
WHERE (udt_schema, udt_name) IN (SELECT type_schema, type_name FROM enum_types) 
AND table_type IN ('BASE TABLE', 'FOREIGN') 
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))

SELECT table_schema, table_name, table_type, column_name, constraint_schema, constraint_name, check_clause
FROM table_check
UNION SELECT table_schema, table_name, table_type, column_name, constraint_schema, constraint_name, check_clause
FROM domain_check
UNION SELECT table_schema, table_name, table_type, column_name, udt_schema, udt_name, 'ENUMERATION TYPE' AS check_clause
FROM enum_cols
ORDER BY table_schema, table_name;