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