diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-08-22 04:52:17 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-08-22 04:52:17 +0000 |
| commit | c76f5aa53032790f5f464ad658c8f65595c12eca (patch) | |
| tree | 71d18dfff0767dc58b763d368a7431f46e9acd82 | |
| parent | 47b37a6bfaa073076c8607cdd4f65ddd569aaefa (diff) | |
| download | postgresql-c76f5aa53032790f5f464ad658c8f65595c12eca.tar.gz postgresql-c76f5aa53032790f5f464ad658c8f65595c12eca.zip | |
> > I had great difficulty in finding how to change the search path, so here
> > is a patch to add some cross-referencing.
Oliver Elphick
| -rw-r--r-- | doc/src/sgml/func.sgml | 13 | ||||
| -rw-r--r-- | doc/src/sgml/runtime.sgml | 6 | ||||
| -rw-r--r-- | doc/src/sgml/syntax.sgml | 7 |
3 files changed, 23 insertions, 3 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 51745a681da..fb387584ed5 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.115 2002/08/21 16:08:19 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.116 2002/08/22 04:52:16 momjian Exp $ PostgreSQL documentation --> @@ -5144,6 +5144,17 @@ SELECT NULLIF(value, '(none)') ... path returned. </para> + <para id=set-search-path xreflabel="SET SEARCH_PATH"> + <indexterm> + <primary>search path</primary> + <secondary>changing at runtime</secondary> + </indexterm> + The search path may be altered by a runtime-alterable GUC setting. The + command to use is <command> + SET SEARCH_PATH '<varname>schema</varname>'[,'<varname>schema</varname>']... + </command> + </para> + <table> <title>System Information Functions</title> <tgroup cols="3"> diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml index 05efc505661..b2d7e4d84f0 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.126 2002/08/18 03:03:25 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.127 2002/08/22 04:52:17 momjian Exp $ --> <Chapter Id="runtime"> @@ -1608,6 +1608,10 @@ dynamic_library_path = '/usr/local/lib/postgresql:/home/my_project/lib:$libdir' </para> <para> + <indexterm> + <primary>schemas</primary> + <secondary>current schema</secondary> + </indexterm> The current effective value of the search path can be examined via the SQL function <function>current_schemas()</>. This is not quite the same as examining the value of diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml index a99a526db18..67d57883c3a 100644 --- a/doc/src/sgml/syntax.sgml +++ b/doc/src/sgml/syntax.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/syntax.sgml,v 1.66 2002/08/13 20:40:43 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/syntax.sgml,v 1.67 2002/08/22 04:52:17 momjian Exp $ --> <chapter id="sql-syntax"> @@ -965,6 +965,11 @@ SELECT 3 OPERATOR(pg_catalog.+) 4; place <literal>pg_catalog</> at the end of your search path if you prefer to have user-defined names override built-in names. </para> + + <para> + The search path is determined by the GUC variable SEARCH_PATH and + may be changed at any time. See <xref linkend="set-search-path">. + </para> </sect2> <sect2 id="sql-reserved-names"> |