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

[GENERAL] how to update structural & data changes between PostgreSQL databases?

2006-03-22 Thread postgresql
Hi, I'm looking for advice on how to update both structural changes and data changes between PostgreSQL databases. Here is my situation: I have both a development and production environment. In the development environment I have a PostgreSQL database that has many tables. Some of the table