| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Michael Shapiro <mshapiro51(at)gmail(dot)com> |
| Cc: | PgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Re: schema diff |
| Date: | 2012-07-18 20:32:09 |
| Message-ID: | 1342643529.1989.82.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2012-07-18 20:37:02 | Re: default parameters |
| Previous Message | Michael Shapiro | 2012-07-18 15:14:13 | schema diff |