SELECT c.table_schema, c.table_name, c.column_name,  c.data_type, c.character_maximum_length, 
CASE WHEN c.character_maximum_length>100 THEN 'Although some names are very long such names are rare and too long field size
may cause more problems than it solves' 
WHEN c.data_type='text' THEN 'Do not forget to put a cap to the length by using a CHECK constraint!'
ELSE 'OK' END AS comment_length,
c.is_nullable,
CASE WHEN c.is_nullable='NO' THEN 'Make sure to accommodate mononymous persons!' ELSE 'OK' END AS comment_nullable
FROM information_schema.columns AS c
WHERE (c.table_schema, c.table_name) IN (SELECT table_schema, table_name
FROM INFORMATION_SCHEMA.tables WHERE table_type='BASE TABLE') AND 
c.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 c.column_name~*'^[_]*(eesnimi|perenimi|perekonnanimi|firstname|first_name|given_name|givenname|surname|family_name|last_name|lastname)[_]*$'
AND (c.character_maximum_length>100 OR c.is_nullable='NO' OR c.data_type='text')
ORDER BY c.table_schema, c.table_name, c.ordinal_position;