Re: Schema comparisons - Mailing list pgsql-admin

From Tom Lane
Subject Re: Schema comparisons
Date
Msg-id 25377.1077942505@sss.pgh.pa.us
Whole thread Raw
In response to Schema comparisons  (Mark Lubratt <mark.lubratt@indeq.com>)
List pgsql-admin
Mark Lubratt <mark.lubratt@indeq.com> writes:
> I've been trying to be careful, but I've gotten out of synch with
> whether or not I've applied the changes I've made to the development
> system to the production system.  Is there a utility that will compare
> the tables, functions, trigger, views, etc. between two systems and
> flag the schema elements that aren't in synch between the two?

Have you tried diffing pg_dump output?  It's not the greatest tool but
it's helpful.

            regards, tom lane

pgsql-admin by date:

Previous
From: Mark Lubratt
Date:
Subject: Schema comparisons
Next
From: Gaetano Mendola
Date:
Subject: Re: ALTER table taking ages...