From: | Nabil Sayegh <nas(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 13:36:44 |
Message-ID: | 1053437804.641.27.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
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Eckermann | 2003-05-20 14:38:40 | Re: table corruption |
Previous Message | Dani Oderbolz | 2003-05-20 13:18:19 | Support for Synonyms? |