Postgres Pro
Downloads
Home   >   mailing lists

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

From Milorad Poluga
Subject How to compare the schemas ?
Date
Msg-id 200506231611.08521.milorad.poluga@cores.co.yu
Whole thread Raw
Responses Re: How to compare the schemas ?  (Peter Eisentraut <peter_e@gmx.net>)
Re: How to compare the schemas ?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-admin
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                      

--
---------------------------------------
Milorad Poluga                        
HK CORES Beograd, Makenzijeva 31
milorad.poluga@cores.co.yu                      
+381-11-30-80-461              
---------------------------------------

pgsql-admin by date:

Previous
From: Paul Keyes
Date:
Subject: moving database to diff. server
Next
From: Michael Fuhr
Date:
Subject: Re: moving database to diff. server