To add pg_temp schema description to schemas documentation

Started by Ilya Anfimovover 3 years ago1 messages

ilan@tzirechnoy.com

over 3 years ago

1 attachment(s)

Good day.

I've found that the pg_temp schema alias is mentioned in the
description of the search_path variable, but is missing from
the schemas documentation section.

I think it would be good to have that there, as that section is
mentioned as an extended reference for schemas.

This patch adds a small paragraph about the temporary schemas
to the schemas documentation section.

Attachments:

tempdoc.patchtext/x-diff; charset=us-asciiDownload

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>