Set search_path for session

From: "Mary Sipple" <msipple(at)iii(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Set search_path for session
Date: 2009-04-17 14:47:11
Message-ID: 005e01c9bf6b$75e13870$61a3a950$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks,

Mary Sipple

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2009-04-17 14:48:33 Re: pgadmin 1.8.4 gives error while backing up
Previous Message Bill Moran 2009-04-17 14:33:15 Re: Looking for advice on database encryption