On 09/10/2014 06:50 AM, Vinayak wrote:
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?
If you are planning on submitting this to .Org you should check the archives for previous discussions on this feature.
jD -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Support, Training, Professional Services and Development High Availability, Oracle Conversion, @cmdpromptinc "If we send our children to Caesar for their education, we should not be surprised when they come back as Romans." -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general