From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Christoph Haller <ch(at)rodos(dot)fzk(dot)de> |
Cc: | pgsql-docs(at)postgresql(dot)org |
Subject: | Re: About SET SEARCH_PATH |
Date: | 2003-09-17 20:40:32 |
Message-ID: | 5602.1063831232@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
Christoph Haller <ch(at)rodos(dot)fzk(dot)de> writes:
>> The search path may be altered by a run-time setting.
>> The command to use is SET SEARCH_PATH 'schema'[,'schema']...
> It should be
> SET SEARCH_PATH TO schema[,schema]...
Actually, you can do it either way:
regression=# set search_path TO a,b,c;
regression=# set search_path TO 'a','b','c';
although not
regression=# set search_path TO 'a,b,c';
ERROR: schema "a,b,c" does not exist
This is mainly for legacy reasons (the grammar involved was originally
used for DateStyle...). I don't object to documenting primarily the
first form, though.
> (2)
> $PGSQLD/doc/html/sql-set.html
> This page does not mention the SEARCH_PATH variable at all.
> Is this intended?
Yeah; that page only documents SET items that are not in the main list
of run-time-configurable parameters.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | monu_indian | 2003-09-18 17:08:49 | buffring in pgsql |
Previous Message | Christoph Haller | 2003-09-17 15:05:16 | About SET SEARCH_PATH |