Re: Table symbolic link - Mailing list pgsql-admin

From Campbell, Lance
Subject Re: Table symbolic link
Date
Msg-id B75CD08C73BD3543B97E4EF3964B7D70203958CA@CITESMBX1.ad.uillinois.edu
Whole thread Raw
In response to Re: Table symbolic link  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-admin

I did not even think about a table view.  I use them very rarely.  I also don’t do update, insert or delete on the view I have.

 

Thanks a lot.  That was really helpful.

 

Lance

 

From: Steve Crawford [mailto:scrawford@pinpointresearch.com]
Sent: Wednesday, May 18, 2016 9:40 AM
To: Joe Conway <mail@joeconway.com>
Cc: Campbell, Lance <lance@illinois.edu>; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Table symbolic link

 

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 by date:

Previous
From: Payal Singh
Date:
Subject: Re: Table symbolic link
Next
From: Albe Laurenz
Date:
Subject: Re: Table symbolic link