Re: how to update structural & data changes between PostgreSQL - Mailing list pgsql-general

From Jim Nasby
Subject Re: how to update structural & data changes between PostgreSQL
Date
Msg-id 640E98AD-15D2-40EF-B7FF-93778E909FD4@pervasive.com
Whole thread Raw
In response to Re: how to update structural & data changes between PostgreSQL  (Jeff Amiel <jamiel@istreamimaging.com>)
List pgsql-general
On Mar 22, 2006, at 9:21 PM, Jeff Amiel wrote:

> We have a fairly 'good' process at our shop that we follow that
> works for us....
>
> First we do a schema comparison between our prod and devl/test
> environments using the EMS PostgreSQL database comparer tool...

Another way to handle this is to keep your database code in a version
control system and tag each release. That way you can generate a diff
between two releases to see what's changed.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461



pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: How to release locks
Next
From: Jim Nasby
Date:
Subject: Re: Enforcing serial uniqueness?