Columns for registration and update times

Copy SQL

SELECT A.table_schema, A.table_name , A.column_name, A.data_type, A.datetime_precision, A.is_nullable, A.column_default, D.domain_default
FROM information_schema.columns A
INNER JOIN information_schema.tables T USING (table_schema, table_name)
INNER JOIN information_schema.schemata S ON A.table_schema=S.schema_name
LEFT JOIN information_schema.domains D USING (domain_schema, domain_name)
WHERE A.data_type~*'(timestamp|date)'
AND (A.column_name~*'(reg|creat|insert|loom|lisam)'
OR (A.column_name~*'(muutm|update|change|modify)'
AND A.column_name!~*'(jargmine|next)'))
AND T.table_type='BASE TABLE'
AND (A.table_schema = 'public'
OR S.schema_owner<>'postgres')
ORDER BY table_schema, table_name, column_name;