diff options
| author | Magnus Hagander | 2020-11-02 14:00:24 +0000 |
|---|---|---|
| committer | Magnus Hagander | 2020-11-02 14:00:24 +0000 |
| commit | 5b3dca096f8e504b73812f68716fb68dd1176d6d (patch) | |
| tree | 47a12c921e556ac77f2bd22a6b0addce8693adbe | |
| parent | 257836a75585934cc05ed7a80bccf8190d41e056 (diff) | |
Clarify temporary table name shadowing in CREATE TABLE docs
Author: David Johnston
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index fd6777ae019..bc59a2d77dd 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -171,8 +171,9 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM If specified, the table is created as a temporary table. Temporary tables are automatically dropped at the end of a session, or optionally at the end of the current transaction - (see <literal>ON COMMIT</literal> below). Existing permanent - tables with the same name are not visible to the current session + (see <literal>ON COMMIT</literal> below). The default + search_path includes the temporary schema first and so identically + named existing permanent tables are not chosen for new plans while the temporary table exists, unless they are referenced with schema-qualified names. Any indexes created on a temporary table are automatically temporary as well. |