Re: schema name in SQL statement.

On Wed, Aug 20, 2008 at 8:13 AM, Adrian Klaver <aklaver(at)comcast(dot)net> wrote:
> From postgresql.conf.sample in ~pgsql/share:
>
>
> #---------------------------------------------------------------------------
> # CLIENT CONNECTION DEFAULTS
> #---------------------------------------------------------------------------
>
> # - Statement Behavior -
>
> #search_path = '"$user",public' # schema names
>
>
> This is how the initial postgresql.conf is set up when you do an initdb. I
> have found the postgresql.conf to be quite well commented.

I have a question (not necessarily to you...)
. How come that syntax parses for postgresql.conf, but in psql it doesn't:

set search_path = '"$user",public' ;
ERROR: schema ""$user",public" does not exist

I have to use this:

set search_path = "$user",public ;
SET