|
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.af2020@xxxxxxxxx>
Sent: Thursday, February 1, 2024 5:50 AM To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx> 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.
|
