Postgres Pro
Downloads
Home   >   mailing lists

Synonyms in PostgreSQL 9.2.4 - Mailing list pgsql-general

From Panneerselvam Posangu
Subject Synonyms in PostgreSQL 9.2.4
Date
Msg-id COL126-W1784D6D55510120783978DDF9F0@phx.gbl
Whole thread Raw
Responses Re: Synonyms in PostgreSQL 9.2.4  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Re: Synonyms in PostgreSQL 9.2.4  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: Streaming replication with sync slave, but disconnects due to missing WAL segments
Next
From: Albe Laurenz
Date:
Subject: Re: Synonyms in PostgreSQL 9.2.4