Am Montag, den 23.05.2005, 23:21 -0300 schrieb jjeffman@xxxxxxxxx:
> 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?
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
