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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
