On Wed, Aug 20, 2008 at 8:13 AM, Adrian Klaver <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
