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@xxxxxxxxx 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@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. > > -- Jim C. Nasby, Database Consultant decibel@xxxxxxxxxxx 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 majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly