Re: How to compare the schemas ?

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