Re: Table symbolic link

Can't you use a simple updateable view? I think a view as "select * from table" would qualify, right?

http://www.postgresql.org/docs/9.5/static/sql-createview.html<http://www.postgresql.org/docs/9.3/static/sql-createview.html>

[http://www.postgresql.org/media/img/docs/hdr_logo.png]<http://www.postgresql.org/docs/9.3/static/sql-createview.html>

PostgreSQL: Documentation: 9.3: CREATE VIEW<http://www.postgresql.org/docs/9.3/static/sql-createview.html>
www.postgresql.org
Description. CREATE VIEW defines a view of a query. The view is not physically materialized. Instead, the query is run every time the view is referenced in a query.

________________________________
From: pgsql-admin-owner(at)postgresql(dot)org <pgsql-admin-owner(at)postgresql(dot)org> on behalf of Campbell, Lance <lance(at)illinois(dot)edu>
Sent: Wednesday, May 18, 2016 9:31 AM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] Table symbolic link

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.

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.

Thanks,

Lance

Web Services @ University of Illinois

Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com

p 512.834.8888
f 512-834-8858

Do you receive our promotional emails? You can subscribe or unsubscribe to those emails at http://go.journyx.com/emailPreference/e/4932/714/