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 (table_schema, table_name) IN (SELECT table_schema, table_name
FROM information_schema.columns
WHERE column_name~*'^[_]*(eesnimi|firstname|first_name|given_name|givenname)[_]*$'
AND is_nullable='YES')
AND (table_schema, table_name) IN (SELECT table_schema, table_name
FROM information_schema.columns
WHERE column_name~*'^[_]*(perenimi|perekonnanimi|given_name|givenname|surname|family_name|last_name|lastname)[_]*$'
AND is_nullable='YES')
AND (table_schema, table_name) NOT IN
(select 
(select nspname from pg_namespace where oid=c.relnamespace) as target_schema,
c.relname as target_table
from pg_constraint o inner join pg_class c on c.oid = o.conrelid
where o.contype = 'c' 
and cardinality(o.conkey)>1
and (substring(pg_get_constraintdef(o.oid),7)~*'is[[:space:]]+not[[:space:]]+null'
or substring(pg_get_constraintdef(o.oid),7)~*'(?<=not.*)is[[:space:]]+null')
and substring(pg_get_constraintdef(o.oid),7)~*'(eesnimi|firstname|first_name|given_name|givenname)'
and substring(pg_get_constraintdef(o.oid),7)~*'(perenimi|perekonnanimi|given_name|givenname|surname|family_name|last_name|lastname)')
ORDER BY table_schema, table_name;