Skip site navigation (1) Skip section navigation (2)

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

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Scott Goodwin <scott(at)scottg(dot)net>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Patch to psql to allow SEARCH_PATH to be set from env
Date: 2004-02-10 13:37:09
Message-ID: 4028DE85.1040209@familyhealth.com.au (view raw or flat)
Thread:
Lists: pgsql-patches
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

In response to

Responses

pgsql-patches by date

Next:From: Scott GoodwinDate: 2004-02-10 13:54:41
Subject: Re: Patch to psql to allow SEARCH_PATH to be set from env
Previous:From: Bruce MomjianDate: 2004-02-10 13:22:02
Subject: Re: Dev version doesn't acknowledge cross type indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group