WITH tables AS (SELECT table_schema, table_name, translate(table_name,'0123456789','') AS table_name_stripped, string_agg(column_name || ' ' || data_type, ',' ORDER BY ordinal_position) AS columns
FROM (SELECT c.table_schema, c.table_name, c.column_name, 
CASE WHEN data_type='numeric' THEN data_type || '(' || numeric_precision || ',' || numeric_scale || ')'
WHEN character_maximum_length IS NOT NULL THEN data_type || '(' ||  character_maximum_length || ')'
WHEN datetime_precision IS NOT NULL AND data_type<>'date' THEN data_type || '(' ||  datetime_precision || ')'
ELSE data_type END AS data_type,
c.ordinal_position
FROM INFORMATION_SCHEMA.columns AS c INNER JOIN INFORMATION_SCHEMA.tables AS t
USING (table_schema, table_name)
WHERE t.table_type='BASE TABLE' AND 
c.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)) AS sq
GROUP BY table_schema, table_name, table_name_stripped)
SELECT columns, string_agg(table_schema || '.' || table_name, ';<br>' ORDER BY table_schema, table_name) AS tables, Count(*) AS number_of_tables
FROM tables
GROUP BY table_name_stripped, columns
HAVING Count(*)>1
ORDER BY Count(*) DESC, columns;