Search Postgresql Archives

Re: Feature request: Per database search_path

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Francisco Reyes <lists@xxxxxxxxxxxxxxxx>
Subject: Re: Feature request: Per database search_path
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Wed, 18 Jul 2007 18:17:59 -0400
Cc: PostgreSQL general <pgsql-general@xxxxxxxxxxxxxx>
Comments: In-reply-to Francisco Reyes <lists@xxxxxxxxxxxxxxxx> message dated "Wed, 18 Jul 2007 16:46:21 -0400"
In-reply-to: <cone.1184791581.174199.99108.5001@xxxxxxxxxxxxxxxxxxx>

Francisco Reyes <lists@xxxxxxxxxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Feature request: Per database search_path
  - From: Francisco Reyes

Prev by Date: Re: Need help optimizing this query
Next by Date: Re: Update of table lags execution of statement by >1 minute?
Previous by thread: Re: Feature request: Per database search_path
Next by thread: Will partial index creation use existing index?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux