postgres.git / summary / log / commit / refs
commit de7b034dafd3847cddcd5f96cca1efce6f7ace8a
Author: Bruce Momjian <bruce@momjian.us>
Date: Wed Dec 16 00:20:15 2020 +0000
First released in: 14.0, 10.16, 11.11, 12.6, 13.2
doc: clarify COPY TO for partitioning/inheritance
It was not clear how COPY TO behaved with partitioning/inheritance
because the paragraphs were so far apart. Also reword to simplify.
Discussion: https://postgr.es/m/20201203211723.GR24052@telsasoft.com
Author: Justin Pryzby
Backpatch-through: 10
doc/src/sgml/ref/copy.sgml | 24 ++++++++++--------------
1 file changed, 10 insertions(+), 14 deletions(-)
diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml
index 18189abc6c9..5ae915ee9ed 100644
--- a/doc/src/sgml/ref/copy.sgml
+++ b/doc/src/sgml/ref/copy.sgml
@@ -411,10 +411,16 @@ COPY <replaceable class="parameter">count</replaceable>
<title>Notes</title>
<para>
- <command>COPY TO</command> can only be used with plain tables, not
- with views. However, you can write <literal>COPY (SELECT * FROM
- <replaceable class="parameter">viewname</replaceable>) TO ...</literal>
- to copy the current contents of a view.
+ <command>COPY TO</command> can be used only with plain
+ tables, not views, and does not copy rows from child tables
+ or child partitions. For example, <literal>COPY <replaceable
+ class="parameter">table</replaceable> TO</literal> copies
+ the same rows as <literal>SELECT * FROM ONLY <replaceable
+ class="parameter">table</replaceable></literal>.
+ The syntax <literal>COPY (SELECT * FROM <replaceable
+ class="parameter">table</replaceable>) TO ...</literal> can be used to
+ dump all of the rows in an inheritance hierarchy, partitioned table,
+ or view.
</para>
<para>
@@ -423,16 +429,6 @@ COPY <replaceable class="parameter">count</replaceable>
<literal>INSTEAD OF INSERT</literal> triggers.
</para>
- <para>
- <command>COPY</command> only deals with the specific table named;
- it does not copy data to or from child tables. Thus for example
- <literal>COPY <replaceable class="parameter">table</replaceable> TO</literal>
- shows the same data as <literal>SELECT * FROM ONLY <replaceable
- class="parameter">table</replaceable></literal>. But <literal>COPY
- (SELECT * FROM <replaceable class="parameter">table</replaceable>) TO ...</literal>
- can be used to dump all of the data in an inheritance hierarchy.
- </para>
-
<para>
You must have select privilege on the table
whose values are read by <command>COPY TO</command>, and
[parent: fde5f130c9c3]