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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
