Tom Lane writes:
> The syntax that comes to mind offhand is
> SET SESSION AUTHORIZATION DEFAULT;
> but perhaps someone has a better idea.
My first thought had been RESET SESSION ... but both are fine, and they're
equivalent for all the other SET commands.
> BTW, I think it's well past time to make pg_dump use SET SESSION
> AUTHORIZATION by default, or even always, instead of \connect commands.
Well, the tradeoff is "restoring user has to be superuser" vs "restoring
user has to know everyone's authentication secrets". The former is
obviously more likely.
--
Peter Eisentraut peter_e(at)gmx(dot)net