query to get list of tables that has same columns from information_schema.columns?
something like this:

select distinct c1.table_schema||'.'||c1.table_name
from information_schema.columns c1
where exists (select 1
              from information_schema.columns c2
              where c2.table_name &lt;&gt; c1.table_name
                and c2.column_name = c1.column_name
                and c2.table_schema = c1.table_schema);