Support for Synonyms?

From: Dani Oderbolz <oderbolz(at)ecologic(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: Support for Synonyms?
Date: 2003-05-20 13:18:19
Message-ID: 3ECA2B1B.7030307@ecologic.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Nabil Sayegh 2003-05-20 13:36:44 Re: Support for Synonyms?
Previous Message Nabil Sayegh 2003-05-20 12:49:26 Re: SELECT across multiple db