WITH data_types AS (SELECT table_schema, table_name, column_name, data_type
FROM INFORMATION_SCHEMA.columns
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))
SELECT column_name, Count(*) AS number_of_columns, Count(DISTINCT data_type) AS number_of_different_types,
string_agg(table_schema ||'.'|| table_name || ' ' || Upper(data_type),';<br>' ORDER BY data_type, table_schema, table_name) AS types
FROM data_types AS dt
GROUP BY column_name
HAVING Count(DISTINCT data_type)>1
ORDER BY Count(DISTINCT data_type) DESC, Count(*) DESC, column_name;