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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to