Well, I can’t just go dropping and recreating tables… it needs to create the correct alter statements if existing tables and or functions already exist. Secondly, when I’m finished changing the structure, I need to be able to select the list of tables that will have content updates. Using a script might be more work maintaining then it’s worth. I have a backup utility that can do the job, but 3 tedious steps per schema, that only work about 10% of the time (and no batching options so that I can create a list of actions and run the list). From: French, Martin [mailto:frenchm@xxxxxxxxxxxxxx] I’m assuming that this needs to be tightly controlled and as such a replication tool is out of the question? In that case; The first thing to pop into my head here would be to use either use shell scripting, or to use the pg API and write a c program to handle it. I remember doing something very similar with Oracle a few years back. Cheers Martin From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Bradley Holbrook Hello! First day on the new mailing list as I have need of some expert’s advice. I need to be able to quickly apply the structure updates from a development database to a testing database, and do selective data updates (like on lookup tables, but not content tables). Any help would be appreciated! Brad
|
