tempdoc.patch

text/x-diff

Download

Patch

Format: unified

File	+	−
doc/src/sgml/ddl.sgml	26	0

diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml
index f2ac1ba0034..8da84d134ce 100644
--- a/doc/src/sgml/ddl.sgml
+++ b/doc/src/sgml/ddl.sgml
@@ -3171,6 +3171,32 @@ REVOKE CREATE ON SCHEMA public FROM PUBLIC;
    </para>
   </sect2>
 
+  <sect2 id="ddl-schemas-temp">
+   <title>The Temporary Schema</title>
+
+   <indexterm zone="ddl-schemas-temp">
+    <primary>pg_temp</primary>
+    <secondary>schema</secondary>
+   </indexterm>
+
+   <para>
+    Another system schema name, implicitly prepended to the search path is pg_temp.
+    This is an alias, that refers to a temporary schema name of the current session.
+    The real name has the form <literal>pg_temp_<replaceable>nnn</replaceable></literal>,
+    if it already exists.
+   </para>
+
+   <para>
+    The implicit <literal>pg_temp</literal> is searched even before the
+    <literal>pg_catalog</literal>. The alias or the specific temporary
+    schema name of the current session that added to the search path will change
+    that search order. However, it is searched only for relation
+    (table, view, sequence, etc) and data type names, and not for function
+    or operator names.
+  </para>
+  </sect2>
+
+
   <sect2 id="ddl-schemas-patterns">
    <title>Usage Patterns</title>