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