[DOCS] 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'

Re: [DOCS] About SET SEARCH_PATH

Christoph Haller <[EMAIL PROTECTED]> 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;