Frank Kurzawa <fkurzawa(at)topazsoftware(dot)com> writes:
> How are people doing automated comparisons of schemas in different databases?
> I've experimented some with 'pg_dump -s' to do this: Do a schema dump
> on the two databases and a diff. But due to myriad small differences
> (order of creation of tables, constraints, etc.) it is very difficult
> to get a usable diff without engaging in massive massage of the dump
> output, including dumping a table at a time.
FWIW, some attention has been paid to this issue recently. I think CVS
tip pg_dump is more useful for this task than existing releases. Don't
suppose you'd want to try it out?
regards, tom lane