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