Re: Comparing two PostgreSQL databases -- order of pg_dump output

Joe Abbate <jma@freedomcircle.com> writes:
> In order to compare the schema of two presumably identical databases, 
> I've been diffing the output of pg_dump -Osx.  However, I've found that 
> the order of the output is not very reliable.

Yeah, we've been around on that before.  pg_dump does actually sort the
output items (modulo dependency requirements), but it sorts by the same
"tag" values that are printed by pg_restore -l, and those aren't currently
designed to be unique.  It's not too clear if we could get away with
changing the definitions of the tag strings.
        regards, tom lane