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.
--
Richard Huxton
Archonet Ltd