How to compare the schemas ?

From: Milorad Poluga <milorad(dot)poluga(at)cores(dot)co(dot)yu>
To: pgsql-general(at)postgresql(dot)org
Subject: How to compare the schemas ?
Date: 2005-06-22 16:36:14
Message-ID: 200506221836.14179.milorad.poluga@cores.co.yu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)poluga(at)cores(dot)co(dot)yu                      

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Roberto Pellagatti 2005-06-22 16:50:40 plpgsql and schema
Previous Message Stephan Szabo 2005-06-22 16:21:33 Re: Problem on function returning setof custom type