Re: About SET SEARCH_PATH

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