Thank you for your inputs, Erik.
Regards,
J. Teja.
> On Jun 4, 2024, at 11:27 AM, Erik Wienhold <ewie@ewie.name> wrote:
>
> On 2024-06-04 19:58 +0200, Teja Jakkidi wrote:
>> Also, is there a way we can remap schema or table during restore like
>> how we have an option to remap in Oracle?
>
> Not in pg_dump or pg_restore. Maybe some third-party tool, but I don't
> know.
>
> I had to do this in the past and just renamed the schemas after
> restoring into a new database. Using a find-and-replace on the SQL dump
> might also work (maybe with a clever regexp) but it's not foolproof if
> the search matches false-positives in data segments or string literals.
>
> --
> Erik