Re: [GENERAL] how to update structural & data changes between PostgreSQL

2006-03-23 Thread Jim Nasby
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

Re: [GENERAL] how to update structural & data changes between PostgreSQL

2006-03-22 Thread Jeff Amiel
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... We extract the DDL changes that it produces ("alter table add column, etc") and place