Skip site navigation (1) Skip section navigation (2)

Re: Schema comparisons

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mark Lubratt <mark(dot)lubratt(at)indeq(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Schema comparisons
Date: 2004-02-28 04:28:25
Message-ID: 25377.1077942505@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
Mark Lubratt <mark(dot)lubratt(at)indeq(dot)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

In response to

Responses

pgsql-hackers by date

Next:From: Shridhar DaithankarDate: 2004-02-28 08:40:27
Subject: Re: Thread safe connection-name mapping in ECPG. Is it
Previous:From: eleinDate: 2004-02-28 04:14:16
Subject: Re: [pgsql-www] Collaboration Tool Proposal

pgsql-admin by date

Next:From: Tsirkin EvgenyDate: 2004-02-28 12:18:45
Subject: Re: copying data between tables
Previous:From: Mark LubrattDate: 2004-02-28 03:32:43
Subject: Schema comparisons

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group