On Thu, Sep 14, 2006 at 12:18:05PM -0700, [EMAIL PROTECTED] wrote: > We have a need to rename some columns, but since we can't update both > the database and the programs instantly, we'd like to temporarily > assign both names to the same column while the updates are in > progress. Something like this would be super nifty :-) > > ALTER TABLE howdy_doody ADD NAME xyzzy TO COLUMN plugh;
If the clients only read the column, you could just add the new column and create triggers that copy the value from the other column on any modification. Later you drop the old column and the triggers. Maybe an approch based on rules might work? Dunno, haven't used them yet. regards, bkw ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
