Nice. Didn't know about that one. -- Kevin Obe, Regina wrote: > There is a fourth way. You can set it just for that database as well > with > > ALTER DATABASE somedb SET search_path to schema1, public; > > In fact a lot of settings you can do at the database level and in 8.3 I > think you can also do it for a specific function. >