Oracle to Postgres Migration

From: Kalyani Maity <bimal(dot)af2020(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Oracle to Postgres Migration
Date: 2024-02-01 10:50:38
Message-ID: CACr=-MX6YEuL2M0hXwr-SoLx1aTpfFmsY0bguQLA11P18RBojQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
I am doing an oracle to postgres migration.

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.

Thanks.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2024-02-01 12:38:16 Re: Oracle to Postgres Migration
Previous Message David G. Johnston 2024-02-01 06:10:49 Re: Basebackup command