Re: table synonyms

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: jjeffman(at)cpovo(dot)net
Cc: Postgresql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: table synonyms
Date: 2005-05-24 06:57:59
Message-ID: 1116917879.6139.14.camel@Andrea.peacock.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Montag, den 23.05.2005, 23:21 -0300 schrieb jjeffman(at)cpovo(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vidya 2005-05-24 07:24:48 Unsubscribe
Previous Message Typing80wpm 2005-05-24 06:44:39 unsubscribe