| 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: | Whole Thread | Raw Message | 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
| 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 |