Is it possible to have multiple names for a column?

Поиск
Список
Период
Сортировка
От felix@crowfix.com
Тема Is it possible to have multiple names for a column?
Дата
Msg-id 20060914191805.GA10037@crowfix.com
обсуждение исходный текст
Ответы Re: Is it possible to have multiple names for a column?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Is it possible to have multiple names for a column?  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: Is it possible to have multiple names for a column?  (Bernhard Weisshuhn <bkw@weisshuhn.de>)
Список pgsql-general
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;

I am pretty certain no such SQL command exists.  But is it possible to
do something sneaky to the internal tables so that two names point to
the same columnand everything just works?  Everything meaning updates,
inserts, etc, not further ALTER TABLE and so on.

--
            ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
     Felix Finch: scarecrow repairman & rocket surgeon / felix@crowfix.com
  GPG = E987 4493 C860 246C 3B1E  6477 7838 76E9 182E 8151 ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o

В списке pgsql-general по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: PostgreSQL slammed by PHP creator
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Is it possible to have multiple names for a column?