I paid $69 and purchased the EMS PostgreSQL DB Comparer tool.
Works great for me......
They have a trial version you can play with...
They even have a command line version......
http://www.sqlmanager.net/en/products/postgresql/dbcomparer
Peter Fein wrote:
>See also the recent thread 'Version Control?' for some tools and a
>discussion of some of the difficulties in doing this robustly.
>
>Milorad Poluga wrote:
>
>
>>Hi everyone,
>>
>>I am looking for the best way to compare the schemas of two databases with the very similar structure.
>>One (certainly not the best options) is to do something like this:
>>
>>pg_dump ... DB1 > PG_SCHEMA1
>>pg_dump ... DB2 > PG_SCHEMA2
>>diff PG_SCHEMA1 PG_SCHEMA2 > differences.txt
>>
>>kwrite differences.txt
>>
>>Any suggestions or ideas on how to overcome this are welcome.
>>
>>Thanks in advance,
>>
>>Milorad Poluga
>>HK CORES Beograd, Makenzijeva 31
>>milorad.poluga@cores.co.yu
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 3: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo@postgresql.org so that your
>> message can get through to the mailing list cleanly
>>
>>
>
>
>
>