I have searched for the word synonym through the whole PostrgeSQL 7.42 pdf documentation and all the ocurrences are from functions redefinitions, and another PostreSQL user has answered me that it does not support tables synonyms, so I am with a big problem : How can I write queries to suport different tables owners ?
Let me explain : I run the same application at different database servers, from different enterprises, and their DBA's can choose the name of the owner of the tables I should query to. How to manage this ? Can I use a parameter to define the table owner ? A macro ? Is there any solution?
Thanks a lot.
Jayme.
----- Original Message ----- From: "Jim C. Nasby" To: Jayme Jeffman Filho Sent: 20-May-2005 13:31:49 -0300 CC: pgsql-general@postgresql.org Subject: Re: [GENERAL] table synonyms I don't remember off the top of my head exactly how synonyms worked, but I'm pretty sure PostgreSQL doesn't directly support them. You might be able to emulate them with rules, though.