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