Re: [GENERAL] Schema - update search_path

2006-10-11 Thread Tom Lane
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)

[GENERAL] Schema - update search_path

2006-10-11 Thread Alvin
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