About SET SEARCH_PATH

Поиск
Список
Период
Сортировка
От Christoph Haller
Тема About SET SEARCH_PATH
Дата
Msg-id 3F68782B.FA15B657@rodos.fzk.de
обсуждение исходный текст
Ответы Re: About SET SEARCH_PATH  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: [pgsql-hackers-win32] Windows CHM format for the documents
Следующее
От: Tom Lane
Дата:
Сообщение: Re: About SET SEARCH_PATH