Postgres Pro
Downloads
Home   >   mailing lists

How to compare the schemas ? - Mailing list pgsql-general

From Milorad Poluga
Subject How to compare the schemas ?
Date
Msg-id 200506221836.14179.milorad.poluga@cores.co.yu
Whole thread Raw
Responses Re: How to compare the schemas ?
List pgsql-general
Tree view 
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                      

pgsql-general by date:

Previous
From: Kapil Malhotra
Date:
Subject: Help me urgently
Next
From: "mrix"
Date:
Subject: fields and foreign keys