On Fri, Aug 29, 2003 at 13:44:49 -0700,
chakkara rangarajan <ranga(at)dvdstation(dot)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.