Thank you for your inputs, Erik. Regards, J. Teja. > On Jun 4, 2024, at 11:27 AM, Erik Wienhold <ewie@xxxxxxxxx> 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
