diff speaks the wrong language to accomplish that, other elementry parts. There exists a program named pgdiff on gborg. On the other hand there's EMS database comparer http://www.sqlmanager.net/ |-----Original Message----- |From: Milorad Poluga [mailto:milorad.poluga@xxxxxxxxxxx] |Sent: Donnerstag, 23. Juni 2005 16:11 |To: pgsql-admin@xxxxxxxxxxxxxx |Subject: [ADMIN] How to compare the schemas ? | | |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@xxxxxxxxxxx | |-- |--------------------------------------- |Milorad Poluga |HK CORES Beograd, Makenzijeva 31 |milorad.poluga@xxxxxxxxxxx |+381-11-30-80-461 |--------------------------------------- | | |---------------------------(end of |broadcast)--------------------------- |TIP 4: Don't 'kill -9' the postmaster |
