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
