Re: Pg schema diff tools Was: [ANNOUNCE] == PostgreSQL Weekly News - April 08 2007 ==

On 4/10/07, Markus Schiltknecht <markus(at)bluegap(dot)ch> wrote:
> Robert Treat wrote:
> > Theres this one which uses tcl:
> > https://sourceforge.net/projects/pgdiff
>
> Seems outdated: 2002, PostgreSQL 7.2, ~1500 lines of code. (which I
> don't really understand, I simply don't know TCL, sorry.)
>
> > And this one which is written in perl:
> > http://gborg.postgresql.org/project/pgdiff/projdisplay.php
>
> Yeah, perl is better with me ;-) Anyway, 2003 also isn't that
> up-to-date either. ~770 lines of code, but that might very well be
> sufficient in many cases.
>
> And as David Fetter pointed out, it's dangerous to rely on such tools,
> as they can never replace a change control process.

no, but it's good to double check your change control process with a
good diff tool. the sqlmanager tool is pretty good but not perfect.
That being said, I think a hand crafted pl/pgsql script is probably
the way to go.

merlin