Postgres Pro
Downloads
Home   >   mailing lists

Re: Feature request: Per database search_path - Mailing list pgsql-general

From Richard Huxton
Subject Re: Feature request: Per database search_path
Date
Msg-id 469EEDFA.3040104@archonet.com
Whole thread Raw
In response to Re: Feature request: Per database search_path  (Francisco Reyes <lists@stringsutils.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Query performance strangeness..
Next
From: "Mikko Partio"
Date:
Subject: Unexpected crash