Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Feature request: Per database search_path
Date
Msg-id 12861.1184797079@sss.pgh.pa.us
Whole thread Raw
In response to Feature request: Per database search_path  (Francisco Reyes <lists@stringsutils.com>)
List pgsql-general
Tree view 
Francisco Reyes <lists@stringsutils.com> writes:
> As far as I know, currently one can set the search path globally, or on a
> per role bases.
> I was wondering if it could be possible to have a per database search_path.

ALTER DATABASE SET search_path = ...

            regards, tom lane

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Need help optimizing this query
Next
From: Tom Lane
Date:
Subject: Re: Update of table lags execution of statement by >1 minute?