It will be a very pleasant idea. Although I am an application developer I don't know if I haveenough knowledge to do that. Do you know how couldI help the PostgreSQL development ?Another feature I missed is the "returning" clause of the Oracle "INSERT" SQL command, which allow the user to retrieve
So the search_path can not substitute the Oracle synonyms function which in a single way allow us to write generic queries for an application no matter the schema which is being used.I can not find a solution on this matter in PostgreSQL.I hope anybody can help me on this subject. The problem is no
Of course! Maybe I am mixing users and schemas, because in Oracle they are the same, the schema has the name of the user which is the owner of the database tables and objects.So the problem can be described as follows :1. Let be Ent01 an enterprise, and Ent02 a different one.2. At Ent01 the databas
Thank you very much for your answer.What happens if there are more than one table with the same name in the "search_path" ?Jayme Jeffman FilhoGSEE-PUCRS+55 51 91123422
I have searched for the word synonym through the wholePostrgeSQL 7.42 pdf documentation and all the ocurrencesare from functions redefinitions, and another PostreSQLuser has answered me that it does not support tablessynonyms, so I am with a big problem : How can I writequeries to suport different
