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
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 |