Francisco Reyes wrote:
>
> Is there a way to unset a role's search_path?
> I had set one role with a particular search path. Now want to take that
> off so the user can get the database's search_path setting.
ALTER ROLE ... RESET search_path;
--
Richard Huxton
Archonet Ltd