Re: Table symbolic link

Lance Campbell wrote:
> 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.
>
> Is this possible? I have not seen a symbolic table name feature but I thought I would ask.
>
> If this is not currently possible it might be something to consider adding.

You can do that with a view:

BEGIN;
ALTER TABLE oldname RENAME TO newname;
CREATE VIEW oldname AS SELECT * FROM newname;
COMMIT;

Yours,
Laurenz Albe