David Garamond <[EMAIL PROTECTED]> writes:
> Is there an easier way?
Use a newer version? pg_dumpall hasn't done it that way since 7.2.
regards, tom lane
---(end of broadcast)---
TIP 8: explain analyze is your friend
All of my non-superusers are restricted from creating databases.
Whenever I upgrade Postgres, I have to hand-edit my dump and change:
CREATE USER usr1 WITH SYSID 101 PASSWORD '...' NOCREATEDB NOCREATEUSER;
into:
CREATE USER usr1 WITH SYSID 101 PASSWORD '...' CREATEDB NOCREATEUSER;
and then af
