Skip site navigation (1) Skip section navigation (2)

How to compare the schemas ?

From: Milorad Poluga <milorad(dot)poluga(at)cores(dot)co(dot)yu>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to compare the schemas ?
Date: 2005-06-23 14:11:08
Message-ID: 200506231611.08521.milorad.poluga@cores.co.yu (view raw or flat)
Thread:
Lists: pgsql-admin
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                      

-- 
---------------------------------------
Milorad Poluga                        
HK CORES Beograd, Makenzijeva 31
milorad(dot)poluga(at)cores(dot)co(dot)yu                      
+381-11-30-80-461              
---------------------------------------


Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2005-06-23 14:33:03
Subject: Re: Are cached IMMUTABLE values persistent between sessions
Previous:From: Donald FraserDate: 2005-06-23 13:26:23
Subject: Are cached IMMUTABLE values persistent between sessions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group