Re: Schema - update search_path

Alvin <dartmissile@yahoo.com> writes:
> Hey guys, I would like to know a good way of updating or appending th=
> e schema names in the search path,

Perhaps like this:

regression=# create schema news;
CREATE SCHEMA
regression=# show search_path;
  search_path
----------------
 "$user",public
(1 row)

regression=# select set_config('search_path', current_setting('search_path') || ',' || quote_ident('news'), false);
     set_config
---------------------
 "$user",public,news
(1 row)

regression=# show search_path;
     search_path
---------------------
 "$user",public,news
(1 row)

regression=#

You should read these two pages for several useful functions:
http://www.postgresql.org/docs/8.1/static/functions-info.html
http://www.postgresql.org/docs/8.1/static/functions-admin.html

            regards, tom lane