From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Table symbolic link |
Date: | 2016-05-18 14:38:38 |
Message-ID: | nhhupe$abe$1@ger.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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"
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Crawford | 2016-05-18 14:39:54 | Re: Table symbolic link |
Previous Message | Scott Whitney | 2016-05-18 14:38:10 | Re: Table symbolic link |