Comparing table structure and contents using pg_dump output from two different databases If I have the output of pg_dump from two different databases, how can I get the difference in structure and contents of all the tables between these two databases?
Simplest way would be to dump the schema as plain sql and use text diff. 

Or you can use tool like apgdiff which produces ddl statements representing the difference between the two database schemas.