Thread: compare database

compare database

From
Sindu
Date:
Hi all,

Is there any script to compare 2 database schema? (not the content, but
the structure).

I tried using "pg_dump -s" and comparing the resulting text file,
unfortunately it seems pg_dump is dumping the tables in OID order
(CMIIW), so the text file output might not be the same depending on the
table creation order.

I've searched the FAQ and contrib, and couldn't find any. I think this
should be in FAQ.

Thanks in advance and best regards,
Sindu