Re: Patch to psql to allow SEARCH_PATH to be set from env

Scott Goodwin wrote:
> Using schemas is fun. Setting the search_path every time I use psql
> isn't. This patch modifies startup.c in psql to allow the SEARCH_PATH to
> be set to whatever the PG_SCHEMA_SEARCH_PATH environment variable is set
> to. If the var is not defined or is empty, no action is taken and the
> search path is what it would be without this patch. If
> PG_SCHEMA_SEARCH_PATH is set to garbage, psql simply reports the
> database error about non-existent schemas and continues running with the
> search_path it would have without this patch. The patch is against PG
> 7.4.1.

Do you know that you can go ALTER USER yourselft SET SEARCH_PATH TO
"'public','core','objects'"; So that will always be your default path?

Chris