On Wed, Aug 20, 2008 at 8:13 AM, Adrian Klaver <aklaver@xxxxxxxxxxx> 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
