| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Vinayak *EXTERN*" <vinpokale(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: CREATE SYNONYM in PostgreSQL |
| Date: | 2014-09-10 14:05:12 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B17D342C6@ntex2010i.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jerry Sievers | 2014-09-10 14:07:36 | Re: CREATE SYNONYM in PostgreSQL |
| Previous Message | Vinayak | 2014-09-10 13:50:33 | CREATE SYNONYM in PostgreSQL |