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, jjeffman@cpovo.net 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 decibel@decibel.org
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?"