Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Eisentraut
Subject Re: How to compare the schemas ?
Date
Msg-id 200506281120.05150.peter_e@gmx.net
Whole thread Raw
In response to How to compare the schemas ?  (Milorad Poluga <milorad.poluga@cores.co.yu>)
Responses Re: How to compare the schemas ?  (Ian FREISLICH <if@hetzner.co.za>)
List pgsql-admin
Tree view 
Milorad Poluga wrote:
> 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

What is wrong with that?

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

pgsql-admin by date:

Previous
From: KÖPFERL Robert
Date:
Subject: Re: How to compare the schemas ?
Next
From: KÖPFERL Robert
Date:
Subject: Direct I/O versus OS-Caching