diff options
Diffstat (limited to 'doc')
| -rw-r--r-- | doc/src/sgml/ref/copy.sgml | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml index df093da97c5..d6859276bed 100644 --- a/doc/src/sgml/ref/copy.sgml +++ b/doc/src/sgml/ref/copy.sgml @@ -520,16 +520,16 @@ COPY <replaceable class="parameter">count</replaceable> <title>Notes</title> <para> - <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. + <command>COPY TO</command> can be used with plain + tables and populated materialized views. + 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>. + However it doesn't directly support other relation types, + such as partitioned tables, inheritance child tables, or views. + To copy all rows from such relations, use <literal>COPY (SELECT * FROM + <replaceable class="parameter">table</replaceable>) TO</literal>. </para> <para> |