I suspect you're mixing users and schemas, but it's been too long since
I've used Oracle, so I'm not sure. Can you provide a more concrete
example? FWIW, I suspect this is a non-issue with postgresql, since the
only hierarchy of objects is schemas, and you can handle that with
search_path.

On Fri, May 20, 2005 at 03:01:34PM -0300, [EMAIL PROTECTED] wrote:
> 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.
> 
> 

-- 
Jim C. Nasby, Database Consultant               [EMAIL PROTECTED] 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to