Thread: Support for Synonyms?

Hi guys,
I just wonder if there is a similar concept as Oracle's SYNONYM
in PostgreSQL.
Using a synonym, you can basically refer from one Schema to another.
For Example in Schema A you have a table called Test.
In Schema B you can then create a synonym to this table:
CREATE SYNONYM Test for A.Test.
This way, you no longer need to reference Test with A.
when selecting from it coming from schema B.

I checked in the manual, but didn't find such a concept.

Thnaks for your help,

Cheers, Dani

Am Die, 2003-05-20 um 15.18 schrieb Dani Oderbolz:
> Hi guys,
> I just wonder if there is a similar concept as Oracle's SYNONYM
> in PostgreSQL.
> Using a synonym, you can basically refer from one Schema to another.
> For Example in Schema A you have a table called Test.
> In Schema B you can then create a synonym to this table:
> CREATE SYNONYM Test for A.Test.
> This way, you no longer need to reference Test with A.
> when selecting from it coming from schema B.

Maybe you want to adjust the search_path ?

cu
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : www.e-trolley.de
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : www.e-trolley.de

Am Die, 2003-05-20 um 15.18 schrieb Dani Oderbolz:
> Hi guys,
> I just wonder if there is a similar concept as Oracle's SYNONYM
> in PostgreSQL.
> Using a synonym, you can basically refer from one Schema to another.
> For Example in Schema A you have a table called Test.
> In Schema B you can then create a synonym to this table:
> CREATE SYNONYM Test for A.Test.
> This way, you no longer need to reference Test with A.
> when selecting from it coming from schema B.

Maybe you want to adjust the search_path ?

cu
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : www.e-trolley.de