Re: Table symbolic link

Поиск
Список
Период
Сортировка
От Steve Crawford
Тема Re: Table symbolic link
Дата
Msg-id CAEfWYyzw0C1XwnVbVMhv2Wk7V=cpQZQaYdn9B4uTzxJgOwB26Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Table symbolic link  (Joe Conway <mail@joeconway.com>)
Ответы Re: Table symbolic link  ("Campbell, Lance" <lance@illinois.edu>)
Список pgsql-admin
As others mentioned, you can create a view. But depending on they types of updates you do, other views that already exist on that table, triggers, and the version of PostgreSQL among other issues it may not be a viable option.

Cheers,
Steve

On Wed, May 18, 2016 at 7:37 AM, Joe Conway <mail@joeconway.com> wrote:
On 05/18/2016 10:31 AM, Campbell, Lance wrote:
> The better strategy would be to rename the table to the new name and add
> a symbolic table that link to the new table name.  Then as I make
> changes to each application I can point them to the new name.  Maybe in
> a year I could delete the symbolic table name.
>
> Is this possible?  I have not seen a symbolic table name feature but I
> thought I would ask.

See CREATE VIEW:
http://www.postgresql.org/docs/9.5/interactive/sql-createview.html

HTH,

Joe

--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development


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

Предыдущее
От: Scott Whitney
Дата:
Сообщение: Re: Table symbolic link
Следующее
От: Payal Singh
Дата:
Сообщение: Re: Table symbolic link