About SET SEARCH_PATH
I'm thinking of introducing schemas within my databases.
Reading the doc I've found some stuff which does not
seem right. I'm referring to 7.3.4.
(1)
$PGSQLD/doc/html/functions-misc.html
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]...
May be a link to
$PGSQLD/doc/html/ddl-schemas.html
should be used instead, it has it all right.
(2)
$PGSQLD/doc/html/sql-set.html
This page does not mention the SEARCH_PATH variable at all.
Is this intended?
Regards, Christoph
Christoph Haller <ch@rodos.fzk.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
On Wed, 17 Sep 2003 16:40:32 -0400, tgl@sss.pgh.pa.us (Tom Lane)
wrote:
Christoph Haller <ch@rodos.fzk.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
But surely not without the 'TO' word, which is how it appears in
6.13 of the User's Guide?
Regards,
Harry.