Re: table synonyms - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: table synonyms
Date
Msg-id 1116917879.6139.14.camel@Andrea.peacock.de
Whole thread Raw
In response to Re: table synonyms  (<jjeffman@cpovo.net>)
Responses Re: table synonyms
List pgsql-general
Am Montag, den 23.05.2005, 23:21 -0300 schrieb jjeffman@cpovo.net:
> So the search_path can not substitute the Oracle synonyms function
> which in a single way allow us to write generic queries for an
> application no matter the schema which is being used.
>
> I can not find a solution on this matter in PostgreSQL.
>
> I hope anybody can help me on this subject. The problem is not to find
> a substitute for the Oracle synonyms, but a way to write queries
> which, reliably, can be used no matter the schema which owns the
> tables.

Maybe you use views?




pgsql-general by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: Does SELECT INTO is affected by default_tablespace?
Next
From: Vidya
Date:
Subject: Unsubscribe