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