Thread: schema diff

schema diff

From
Michael Shapiro
Date:
I would like to to request a schema diff feature -- see the  differences between the schemas of two databases.<br />I
realizethis could be done with backup and an external diff tool, but it is cumbersome and generic diff tools don't give
thenecessary browsing capabilities. <br /><br />For example it would be nice to see<br />* which tables, views,
functions,etc are missing from one schema vs the other<br />* which tables, views, functions, etc are different from
oneschema vs the other (and then "click" on one to see the differences)<br /><br /> 

Re: schema diff

From
Guillaume Lelarge
Date:
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