Re: Database Comparison tool?

[ please refrain from top-quoting, and try not to repeat the entire
  previous post; we do have archives you know ]

Rick Gigger <rick@alpinenetworking.com> writes:
> On Feb 9, 2006, at 1:03 PM, Philippe Ferreira wrote:
>> Do a "pgdump" of both databases, and use the "diff" tool to compare
>> the two generated files !

> Is the ordering guaranteed to be the same on both boxes if you do this?

For recent pg_dumps (since 8.0 I think) it should be the same as long
as both DBs are actually identical.  If there are different interobject
dependencies, that might force different dump orders.

            regards, tom lane