diff options
Diffstat (limited to 'doc')
-rw-r--r-- | doc/src/sgml/ref/copy.sgml | 11 | ||||
-rw-r--r-- | doc/src/sgml/ref/pg_checksums.sgml | 4 |
2 files changed, 10 insertions, 5 deletions
diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml index c2d1fbc1fbe..fdc24b36bb8 100644 --- a/doc/src/sgml/ref/copy.sgml +++ b/doc/src/sgml/ref/copy.sgml @@ -539,13 +539,14 @@ COPY <replaceable class="parameter">count</replaceable> <para> <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 + tables, populated materialized views, and partitioned tables. + For non-partitioned tables, COPY <replaceable class="parameter">table</replaceable> + copies the same rows as <literal>SELECT * FROM ONLY <replaceable class="parameter">table</replaceable></literal>. + For partitioned tables, it copies the same rows as + <literal>SELECT * FROM <replaceable class="parameter">table</replaceable></literal>. However it doesn't directly support other relation types, - such as partitioned tables, inheritance child tables, or views. + such as 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> diff --git a/doc/src/sgml/ref/pg_checksums.sgml b/doc/src/sgml/ref/pg_checksums.sgml index 95043aa329c..e9e393495df 100644 --- a/doc/src/sgml/ref/pg_checksums.sgml +++ b/doc/src/sgml/ref/pg_checksums.sgml @@ -247,5 +247,9 @@ PostgreSQL documentation remains unchanged, and <application>pg_checksums</application> can be re-run to perform the same operation. </para> + <para> + The target cluster must have the same major version as + <application>pg_checksums</application>. + </para> </refsect1> </refentry> |