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 [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgpgFIvnPhGZA.pgp
Description: PGP signature
