SELECT table_type, table_schema, table_name, column_name,  data_type, character_maximum_length
FROM INFORMATION_SCHEMA.columns AS c INNER JOIN INFORMATION_SCHEMA.tables USING (table_schema, table_name)
WHERE data_type~*'(char|text|integer|smallint|bigint|numeric|decimal|real|float|double precision)'
AND column_name~*'(^|_)(kestus|kestvus|duration)$'
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)
AND EXISTS (SELECT * 
FROM INFORMATION_SCHEMA.columns AS c2
WHERE c.table_schema=c2.table_schema
AND c.table_name=c2.table_name
AND c2.column_name~*'(algus|beginning|start)$'
AND c2.data_type~*'(date|timestamp)')
ORDER BY table_type, table_schema, table_name, ordinal_position;