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@xxxxxxxxxxxxxx
Subject: Re: 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.
