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

About SET SEARCH_PATH

From: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
To: pgsql-docs(at)postgresql(dot)org
Subject: About SET SEARCH_PATH
Date: 2003-09-17 15:05:16
Message-ID: 3F68782B.FA15B657@rodos.fzk.de (view raw or flat)
Thread:
Lists: pgsql-docs
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



Responses

pgsql-docs by date

Next:From: Tom LaneDate: 2003-09-17 20:40:32
Subject: Re: About SET SEARCH_PATH
Previous:From: Darko PrenosilDate: 2003-09-14 14:47:48
Subject: Re: [DOCS] Windows CHM format for the documents

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