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)
Hey guys, I would like to know a good way of updating or appending the schema names in the search path, Right now I do a show search_path, get the names of all the schemas, and then set search path; adding the new schema. I'm in the process of integrating a few systems and will need to continuously