Inconsistent data types for audit timestamps

Copy SQL

WITH columns AS (SELECT table_schema, table_name, column_name, data_type
FROM INFORMATION_SCHEMA.columns AS c
WHERE (table_schema, table_name) IN (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 column_name~*'(reg|lisa|create|add|muut|update)'
AND column_name!~*'(tahtaeg)'
AND data_type~*'(timestamp|date)'),
columns_agg AS (SELECT data_type, string_agg(table_schema || '.' || table_name || '.' || column_name ,'<br>' ORDER BY table_schema, table_name, column_name) AS table_columns, Count(column_name) AS nr_of_columns
FROM columns
GROUP BY data_type)
SELECT data_type, table_columns, nr_of_columns
FROM columns_agg
GROUP BY data_type, table_columns, nr_of_columns
HAVING (SELECT Count(*) AS cnt FROM columns_agg)>1
ORDER BY nr_of_columns DESC, data_type;