Support for Synonyms?

Поиск
Список
Период
Сортировка
От Dani Oderbolz
Тема Support for Synonyms?
Дата
Msg-id 3ECA2B1B.7030307@ecologic.de
обсуждение исходный текст
Ответы Re: Support for Synonyms?  (Nabil Sayegh <postgresql@e-trolley.de>)
Re: Support for Synonyms?  (Nabil Sayegh <nas@e-trolley.de>)
Список 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 по дате отправления:

Предыдущее
От: Nabil Sayegh
Дата:
Сообщение: Re: SELECT across multiple db
Следующее
От: Jeff Eckermann
Дата:
Сообщение: Re: table corruption