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