X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 9E582D1B510 for ; Wed, 17 Sep 2003 20:41:03 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 94496-07 for ; Wed, 17 Sep 2003 17:40:33 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 79E25D1B4EF for ; Wed, 17 Sep 2003 17:40:31 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h8HKeWpr005603; Wed, 17 Sep 2003 16:40:33 -0400 (EDT) To: Christoph Haller Cc: pgsql-docs@postgresql.org Subject: Re: About SET SEARCH_PATH In-reply-to: <3F68782B.FA15B657@rodos.fzk.de> References: <3F68782B.FA15B657@rodos.fzk.de> Comments: In-reply-to Christoph Haller message dated "Wed, 17 Sep 2003 17:05:16 +0200" Date: Wed, 17 Sep 2003 16:40:32 -0400 Message-ID: <5602.1063831232@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/52 X-Sequence-Number: 2008 Christoph Haller 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