Thread: Synonyms in PostgreSQL 9.2.4

Synonyms in PostgreSQL 9.2.4

From
Panneerselvam Posangu
Date:
Hi,

I am currently working on a conversion project. We plan to make our application PostgreSQL compliant. And for this we have chosen PosgreSQL 9.2.4.

Currently our application works along with Oracle 11g. In Oracle schema we have created Synonyms. The context is this: 
In Oracle schema we have couple of users. They own tables, views, and other objects. We create synonyms for a given object ,grant needed privilege and provide those synonyms to the users other than the owners.

Is there any work-around you could suggest in PostgreSQL?

Thanks in advance,
Panneerselvam Posangu