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

On Wed, Jul 18, 2007 at 11:02:51PM +0100, Richard Huxton wrote:
> Francisco Reyes wrote:
> >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.
> >I believe this would be not only convenient, but will add flexibility.
>
>
> ALTER DATABASE leia SET search_path = public,lookups;
>
> Seems to work for me on 8.2 - you'll need to disconnect and reconnect to
> see it take place though.

BTW, in case it's not obvious, that works with pretty much anything that
session-setable. Same with ALTER ROLE ... SET.
--
Jim Nasby                                      decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)