Inconsistent time zone and precision usage in case of registering timestamps

Copy SQL

WITH num_cols AS (SELECT table_schema, table_name, column_name, ordinal_position, 
CASE WHEN datetime_precision IS NOT NULL THEN data_type || '(' || datetime_precision || ')'
ELSE data_type END AS data_type
FROM INFORMATION_SCHEMA.columns
WHERE data_type~*'timestamp' 
AND (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))
SELECT data_type, string_agg(table_schema || '.' || table_name || '.' || column_name, ',<br>' ORDER BY table_schema, table_name) AS tables, Count(*) AS number_of_columns
FROM num_cols
WHERE (SELECT Count(DISTINCT data_type) AS cnt FROM num_cols)>1
GROUP BY data_type
ORDER BY Count(*) DESC, data_type;