Re: CREATE SYNONYM in PostgreSQL

Vinayak <vinpokale@gmail.com> writes:

> Hello,
> 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?

The fine people at EnterpriseDB offer "Postgres Plus Advanced SErver"
which implements this and many other Oracle look allike features.

HTH
>
>
>
>
> -----
> Regards,
> Vinayak,
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/CREATE-SYNONYM-in-PostgreSQL-tp5818446.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800