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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110