Re: Oracle to Postgres Migration

Kalyani,
If you want to refer newly migrated procedure, procedure1 which is now existing in the schema, scheam2, your solution is correct.

create synonym 'schema1.procedure1' for 'schema2.procedure1'
Thanks,

________________________________
From: Kalyani Maity <bimal(dot)af2020(at)gmail(dot)com>
Sent: Thursday, February 1, 2024 5:50 AM
To: pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Oracle to Postgres Migration

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.