Thread: schema diff
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 />
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