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@cores.co.yu
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
--
Peter Fein pfein@pobox.com 773-575-0694
Basically, if you're not a utopianist, you're a schmuck. -J. Feldman