Re: Support for Synonyms?

From: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
To: Dani Oderbolz <oderbolz(at)ecologic(dot)de>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Support for Synonyms?
Date: 2003-05-20 14:50:56
Message-ID: 1053442256.632.3.camel@billy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2003-05-20 16:22:02 Re: table corruption
Previous Message Jeff Eckermann 2003-05-20 14:38:40 Re: table corruption