Compare structure of two tables

gistfile1.sql

SELECT old.column_name as column_1141, old.data_type as type_1141, new.column_name as column_1142, new.data_type as type_1142
FROM
(SELECT * FROM information_schema.columns WHERE table_schema = 'old_schema' AND table_name = 'old_table') old
FULL OUTER JOIN
(SELECT * FROM information_schema.columns WHERE table_schema = 'new_schema' AND table_name = 'new_table') new
USING (column_name)
WHERE old.column_name IS DISTINCT FROM new.column_name
   OR old.data_type != new.data_type
ORDER BY COALESCE(old.column_name, new.column_name) ASC;