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 [EMAIL PROTECTED] -- --------------------------------------- Milorad Poluga HK CORES Beograd, Makenzijeva 31 [EMAIL PROTECTED] +381-11-30-80-461 --------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
