Re: [GENERAL] Schema search_path and $user

2009-07-06 Thread Postgres User
Thanks for the link, I wasn't reading the right page(s) in the documentation.

On Mon, Jul 6, 2009 at 12:19 PM, Tom Lane wrote:
> Postgres User  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
>

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Schema search_path and $user

2009-07-06 Thread Tom Lane
Postgres User  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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general