Re: CREATE SYNONYM in PostgreSQL

Vinayak wrote:
> We are converting the Oracle's CREATE SYNONYM statement into PostgreSQL.
> I think to replace the SYNONYM we use search_path in PostgreSQL and the same
> thing is explained in the below post also.
> http://postgresql.1045698.n5.nabble.com/Synonyms-in-PostgreSQL-9-2-4-td5757986.html
> 
> Is there any way to automate the oracle's CREATE SYNONYM in PostgreSQL or
> can we use hook like post_parse_analyze_hook to implement this?
> Thought?

If search_path is too coarse (affects all objects in a schema), I recommend that
you use views to replace Oracle's synonyms.

Yours,
Laurenz Albe