Re: schema diff - Mailing list pgadmin-support

From Guillaume Lelarge
Subject Re: schema diff
Date
Msg-id 1342643529.1989.82.camel@localhost.localdomain
Whole thread Raw
In response to schema diff  (Michael Shapiro <mshapiro51@gmail.com>)
List pgadmin-support
On Wed, 2012-07-18 at 10:14 -0500, Michael Shapiro wrote:
> I would like to to request a schema diff feature -- see the  differences
> between the schemas of two databases.
> I realize this could be done with backup and an external diff tool, but it
> is cumbersome and generic diff tools don't give the necessary browsing
> capabilities.
> 
> For example it would be nice to see
> * which tables, views, functions, etc are missing from one schema vs the
> other
> * which tables, views, functions, etc are different from one schema vs the
> other (and then "click" on one to see the differences)

A GSOC student tried to work on this in 2010. See
http://wiki.postgresql.org/wiki/Database_Schema_diff_GSoC_2010 for more
details. It didn't get too far AFAIR.

It would be a good idea, but we lack contributors to work on such a
feature.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



pgadmin-support by date:

Previous
From: Michael Shapiro
Date:
Subject: schema diff
Next
From: Guillaume Lelarge
Date:
Subject: Re: default parameters