Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2012
    Posts
    2

    Question 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?

  2. #2
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    Why not change the code to be consistent?

    The view should work, but may be confusing to people who have to maintain this later. . .

  3. #3
    Join Date
    Aug 2012
    Posts
    2

    Red face 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.

  4. #4
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •