WITH state_enum AS (SELECT t.oid, nspname AS type_schema, typname, array_agg(enumlabel ORDER BY enumsortorder) AS values
FROM pg_catalog.pg_type t LEFT JOIN pg_catalog.pg_enum e ON t.oid=e.enumtypid
INNER JOIN pg_catalog.pg_namespace n ON n.oid=t.typnamespace
WHERE nspname NOT IN (SELECT schema_name
FROM INFORMATION_SCHEMA.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL) 
AND typtype='e'
GROUP BY t.oid, nspname, typname),
cols AS (SELECT n.nspname AS table_schema,
c.relname AS table_name,
a.attname AS column_name,
CASE WHEN t.typbasetype<>0 THEN t.typbasetype ELSE t.oid END AS type_oid
FROM pg_class AS c INNER JOIN pg_namespace AS n ON n.oid=c.relnamespace
LEFT JOIN pg_attribute AS a ON a.attrelid = c.oid
LEFT JOIN pg_type AS t ON a.atttypid=t.oid
WHERE c.relkind='r')
SELECT cols.table_schema, cols.table_name, cols.column_name,
e.type_schema AS enum_type_schema,
e.typname AS enum_type,
e.values AS type_values
FROM cols INNER JOIN state_enum AS e ON e.oid=cols.type_oid
WHERE (e.typname~*'(olek|staatus|seisund|state(?!ment)|status)'
OR cols.column_name~*'(olek|staatus|seisund|state(?!ment)|status)')
ORDER BY table_schema, table_name;