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