On Sun, Jul 25, 2021 at 8:02 PM Ganesh Korde <ganeshako...@gmail.com> wrote:
> You just need to export dump without any privileges. And while restoring > dump use the new role. > You should read the body of the original email and not just the subject line. The actual question pertains to schemas - which IIUC are tightly linked to roles in other DBs (hence the observed behavior elsewhere) but aside from some default search_path stuff are unrelated in PostgreSQL. David J.
