var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: An alternative to CREATE ALIAS or CREATE SYNONYMS
Once the postgree have not support for table ALIAS or SYNONYMS, we are using view to try to solve some problems.
I have two programs which have to access the same table on database, but one software try to access the "tb_mytable" while another try to access the "tb_othertable".
To solve the problem we use "CREATE VIEW tb_mytable AS SELECT * FROM tb_othertable"
I was wondering if that solution is the best, if this solution has performance problem and if there is any other way to solve this problem on the postgresql.
Can anyone help me?
Why not change the code to be consistent?
The view should work, but may be confusing to people who have to maintain this later. . .
I wish, but I can't.
I wish I could change the code, but this not matter, I just want to know if this solution have performance issues and if there is a way to solve the problem in postgresql without views.
There should be very little performance impact (if any is detectable), but it would be quite easy to run a few tests and compare the results . . .
Tags for this Thread