Re: Feature request: Per database search_path

From: Richard Huxton <dev(at)archonet(dot)com>
To: Francisco Reyes <lists(at)stringsutils(dot)com>, PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Feature request: Per database search_path
Date: 2007-07-19 04:52:10
Message-ID: 469EEDFA.3040104@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mikko Partio 2007-07-19 05:37:54 Unexpected crash
Previous Message Richard Huxton 2007-07-19 04:49:52 Re: Query performance strangeness..