Re: Schema search_path and $user

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Schema search_path and $user
Дата
Msg-id 19966.1246907997@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Schema search_path and $user  (Postgres User <postgres.developer@gmail.com>)
Ответы Re: Schema search_path and $user
Список pgsql-general
Postgres User <postgres.developer@gmail.com> writes:
> In the docs, I see repeated references to $user in the postgresql.conf
> schema search_path setting such as:

> search_path = '"$user",public'

> But I don't see any info on the meaning of '$user' here.

I guess you didn't read the actual documentation of search_path:
http://www.postgresql.org/docs/8.3/static/runtime-config-client.html#GUC-SEARCH-PATH
It says

The value for search_path has to be a comma-separated list of schema
names. If one of the list items is the special value $user, then the
schema having the name returned by SESSION_USER is substituted, if there
is such a schema. (If not, $user is ignored.)

            regards, tom lane

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

Предыдущее
От: Postgres User
Дата:
Сообщение: Schema search_path and $user
Следующее
От: Postgres User
Дата:
Сообщение: Re: Schema search_path and $user