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(dot)poluga(at)cores(dot)co(dot)yu
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
Peter Fein pfein(at)pobox(dot)com 773-575-0694

Basically, if you're not a utopianist, you're a schmuck. -J. Feldman