On Thu, 2024-02-01 at 16:20 +0530, Kalyani Maity wrote: > I have one scenario where one synonym created as below in oracle DB: > > create synonym 'schema1.procedure1' for 'schema2.procedure1' > > procedure1 only exist in schema2. > > I have migrated both schema 1 and schema 2 in postgres. > > How to create this synonym in postgres. You don't. Instead, you set "search_path" to include both schemas. Yours, Laurenz Albe
