Re: How do people do schema upgrades?

On Mon, Feb 17, 2003 at 10:12:21PM +0100, Steinar Bang wrote:
>
> The problem is how to create the "patch files".  Is there a way to
> calculate the differences between the schemas of two databases, and
> create a set of SQL commands to transform one into the other?

There's a pg_diff utility on the web somewhere.  It requires quite a
piece of infrastructure to make it work, though.

My own suggestion is CVS logs, but that assumes you are tracking the
changes made to the database.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110