Re: synonym and design tool

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: synonym and design tool
Дата
Msg-id 20030830020001.GA30027@wolff.to
обсуждение исходный текст
Ответ на synonym and design tool  ("chakkara rangarajan" <ranga@dvdstation.com>)
Ответы Re: synonym and design tool  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
On Fri, Aug 29, 2003 at 13:44:49 -0700,
  chakkara rangarajan <ranga@dvdstation.com> wrote:
> Hi,
>
> I am coming with an oracle background. In oracle, if user A wants to access
> the objects of user B, User A has got 2 options:
>
> 1. Access the object using dot notation
>
> 2. Access the object after creating a synonym for the user B object in USER
> A schema and access the object using the synonym.
>
>
>
> Is there any equivalency in PGsql and if so, please let me know.

In 7.3 and above you can do option one using schemas.
There isn't any equivalent of synonyms.

В списке pgsql-novice по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Database names and pg_dump
Следующее
От: Tom Lane
Дата:
Сообщение: Re: synonym and design tool