Thanks for the responses everyone and the reality check of how new features get in. I will look into the suggestion by Vijaykumar in more detail and try it out.
Thanks again, Mayan On Sun, Jul 25, 2021 at 10:11 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > 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. > >