Re: Set search_path for session - Mailing list pgsql-general

From Scott Mead
Subject Re: Set search_path for session
Date
Msg-id d3ab2ec80904170853h23235e1bp6acf7015ef2e9fe8@mail.gmail.com
Whole thread Raw
In response to Set search_path for session  ("Mary Sipple" <msipple@iii.com>)
List pgsql-general

On Fri, Apr 17, 2009 at 10:47 AM, Mary Sipple <msipple@iii.com> wrote:

We have a script wrapper for psql which reads a configuration file and constructs a psql command to connect to the configured instance of postgres. We would like to include a search_path setting in the configuraration file and have the wrapper use that to set the search_path for the psql session. I tried using the -v flag (-vsearch_path=xxxx) with the psql command but that did not work:

> psql -h$SOCKET -U$USER -p$PORT -vsearch_path=$SCHEMAS $DBNAME

The search_path remains at the default setting:

iii=> show search_path;

  search_path  

----------------

 "$user",public

(1 row)

Can anyone tell me how I can make this happen short of changing the search_path setting in postgresql.conf & restarting postgres?


In your users's home directory, place a '.psqlrc' file with the command 'set search_path=<blah>'

http://www.postgresql.org/docs/8.3/static/app-psql.html


--Scott

pgsql-general by date:

Previous
From: Scott Mead
Date:
Subject: Re: Set search_path for session
Next
From: Alvaro Herrera
Date:
Subject: Re: Set search_path for session