Support for Synonyms? - Mailing list pgsql-novice

From Dani Oderbolz
Subject Support for Synonyms?
Date
Msg-id 3ECA2B1B.7030307@ecologic.de
Whole thread Raw
Responses Re: Support for Synonyms?
Re: Support for Synonyms?
List 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


pgsql-novice by date:

Previous
From: Nabil Sayegh
Date:
Subject: Re: SELECT across multiple db
Next
From: Jeff Eckermann
Date:
Subject: Re: table corruption