Re: Table symbolic link

Campbell, Lance schrieb am 18.05.2016 um 16:31:
> PostgreSQL 9.5.x
>
> I have 16 web applications using a single database. Some of the
> tables in the database are used by many of the applications. I wanted
> to rename a particular table. The issue is that I would have to
> change every application then stop all the applications and then
> redeploy them after renaming the table to the new name.
>
> 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.
>

Create a view with the old name that does a "select * from new_table_name"