| From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
|---|---|
| To: | Joe Conway <mail(at)joeconway(dot)com> |
| Cc: | "Campbell, Lance" <lance(at)illinois(dot)edu>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Table symbolic link |
| Date: | 2016-05-18 14:39:54 |
| Message-ID: | CAEfWYyzw0C1XwnVbVMhv2Wk7V=cpQZQaYdn9B4uTzxJgOwB26Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)joeconway(dot)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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Campbell, Lance | 2016-05-18 14:41:03 | Re: Table symbolic link |
| Previous Message | Thomas Kellerer | 2016-05-18 14:38:38 | Re: Table symbolic link |