Is there any interest in an optional mode for pg_dump to order the output so that it's easier to use diff? I don't think it would make the output 100% deterministic, but it would make it easier to at least compare the data for small databases. I think this has been brought up before, but I couldn't find the thread, so I don't know what conclusion was reached. Regards, Jeff Davis -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general