On tis, 2011-08-30 at 19:11 -0400, Stephen Frost wrote:
> * Joe Abbate (jma(at)freedomcircle(dot)com) wrote:
> > In order to compare the schema of two presumably identical
> > databases, I've been diffing the output of pg_dump -Osx.
>
> I'm not sure exactly how it does it, but check_postgres.pl offers this.
>
> http://bucardo.org/wiki/Check_postgres
That tool is also not without bugs in this regard.
Also, the interface it works with necessarily doesn't offer a good way
to examine the differences in detail; it only shows you that there are
differences.