Re: synonym and design tool - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: synonym and design tool
Date
Msg-id 20030830020001.GA30027@wolff.to
Whole thread Raw
In response to synonym and design tool  ("chakkara rangarajan" <ranga@dvdstation.com>)
Responses Re: synonym and design tool
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Database names and pg_dump
Next
From: Tom Lane
Date:
Subject: Re: synonym and design tool