Synonyms in PostgreSQL 9.2.4

From: Panneerselvam Posangu <panneerpps(at)hotmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Synonyms in PostgreSQL 9.2.4
Date: 2013-06-05 08:29:39
Message-ID: COL126-W1557B8CC94521B4DC8F7FADF9F0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2013-06-05 08:30:42 Re: Streaming replication with sync slave, but disconnects due to missing WAL segments
Previous Message 任洪彩 2013-06-05 02:02:04 Re: How to modify dump files created by pg_dump