Set search_path for session

Поиск
Список
Период
Сортировка
От Mary Sipple
Тема Set search_path for session
Дата
Msg-id 005e01c9bf6b$75e13870$61a3a950$@com
обсуждение исходный текст
Ответы Re: Set search_path for session  (Scott Mead <scott.lists@enterprisedb.com>)
Re: Set search_path for session  (Scott Mead <scott.mead@enterprisedb.com>)
Re: Set search_path for session  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Set search_path for session  (Scott Marlowe <scott.marlowe@gmail.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: pgadmin 1.8.4 gives error while backing up
Следующее
От: sub_woofer
Дата:
Сообщение: Re: Trigger error