patternsqlMinor
Comparing table structure and contents using pg_dump output from two different databases
Viewed 0 times
pg_dumpcomparingdatabasescontentsoutputdifferenttwostructureusingand
Problem
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?Solution
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.
Or you can use tool like apgdiff which produces ddl statements representing the difference between the two database schemas.
Context
StackExchange Database Administrators Q#31862, answer score: 4
Revisions (0)
No revisions yet.