About SET SEARCH_PATH - Mailing list pgsql-docs

From Christoph Haller
Subject About SET SEARCH_PATH
Date
Msg-id 3F68782B.FA15B657@rodos.fzk.de
Whole thread Raw
Responses Re: About SET SEARCH_PATH
List 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



pgsql-docs by date:

Previous
From: "Dave Page"
Date:
Subject: Re: [pgsql-hackers-win32] Windows CHM format for the documents
Next
From: Tom Lane
Date:
Subject: Re: About SET SEARCH_PATH