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
