[ please refrain from top-quoting, and try not to repeat the entire
previous post; we do have archives you know ]
Rick Gigger <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
