Joe Abbate <j...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers