title: add schema to path in postgresql
body: <p>I'm the process of moving applications over from all in the public schema to each having their own schema.  for each application, I have a small script that will create the schema and then create the tables,functions,etc... to that schema.  Is there anyway to automatically add a newly created schema to the search_path?  Currently, the only way I see is to find the users current path <code>SHOW search_path;</code>  and then add the new schema to it <code>SET search_path to xxx,yyy,zzz;</code></p>
  
  <p>I would like some way to just say,  append schema zzz to the users_search path.  is this possible?</p>