Alvin <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
