with fk AS (select 
(select nspname from pg_namespace where oid=c.relnamespace) as fk_schema,
c.relname as fk_table, 
c.oid as fk_table_oid,
o.conkey AS fk_col
from pg_constraint o inner join pg_class c on c.oid = o.conrelid
where o.contype='f' and c.relkind = 'r'),
keys_unnest as (select fk_schema, fk_table, fk_table_oid, fk_col, fk_col_num
from fk, unnest(fk.fk_col) with ordinality as f(fk_col_num, ordin)),
keys_with_names as (select fk_schema, fk_table, a_target.attname fk_column
from keys_unnest k inner join  pg_attribute a_target on k.fk_col_num = a_target.attnum and k.fk_table_oid = a_target.attrelid and a_target.attisdropped = false)
SELECT c.table_schema, c.table_name , c.column_name
FROM information_schema.columns c INNER JOIN information_schema.tables T USING (table_schema, table_name)
INNER JOIN information_schema.schemata S ON c.table_schema=S.schema_name
LEFT JOIN information_schema.domains d USING (domain_schema, domain_name)
WHERE coalesce(c.column_default, d.domain_default) IS NULL 
AND T.table_type='BASE TABLE'
AND c.column_name~*'(olek|staatus|seisund|state(?!ment)|status)'
AND (c.table_schema, c.table_name , c.column_name) NOT IN
(SELECT table_constraints.table_schema, table_constraints.table_name, constraint_column_usage.column_name
FROM information_schema.table_constraints INNER JOIN information_schema.constraint_column_usage
USING (table_schema, table_name, constraint_name)
WHERE table_constraints.constraint_type IN ('PRIMARY KEY', 'UNIQUE')) 
AND (c.table_schema, c.table_name , c.column_name) IN (
SELECT fk_schema, fk_table, fk_column
FROM keys_with_names)
AND (c.table_schema = 'public'
OR S.schema_owner<>'postgres')
ORDER BY c.table_schema, c.table_name, c.column_name;