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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
