See also the recent thread 'Version Control?' for some tools and a
discussion of some of the difficulties in doing this robustly.
Milorad Poluga wrote:
> 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@xxxxxxxxxxx
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
> message can get through to the mailing list cleanly
--
Peter Fein pfein@xxxxxxxxx 773-575-0694
Basically, if you're not a utopianist, you're a schmuck. -J. Feldman
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
