Skip site navigation (1) Skip section navigation (2)

Re: About SET SEARCH_PATH

From: Harry Broomhall <harry(dot)broomhall(at)uk(dot)easynet(dot)net>
To: pgsql-docs(at)postgresql(dot)org
Subject: Re: About SET SEARCH_PATH
Date: 2003-09-19 14:13:10
Message-ID: cl3mmvki148sqb7uka06o9smk0a8sb3enc@4ax.com (view raw or flat)
Thread:
Lists: pgsql-docs
On Wed, 17 Sep 2003 16:40:32 -0400, tgl(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane)
wrote:

>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
>

   But surely not without the 'TO' word, which is how it appears in
6.13 of the User's Guide?

   Regards,
          Harry.


In response to

Responses

pgsql-docs by date

Next:From: Tom LaneDate: 2003-09-19 16:09:40
Subject: Re: About SET SEARCH_PATH
Previous:From: scott.marloweDate: 2003-09-18 19:37:29
Subject: Re: buffring in pgsql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group