diff options
| author | Fujii Masao <fujii@postgresql.org> | 2025-04-04 19:32:00 +0900 |
|---|---|---|
| committer | Fujii Masao <fujii@postgresql.org> | 2025-04-04 19:32:00 +0900 |
| commit | 534874fac0b34535c9a5ab9257d6574f78423578 (patch) | |
| tree | c92b33bfbd8fa96270cf5215047fb02030c022a6 /doc/src | |
| parent | 9ef1851685b718264de47bf543505cf3ec25aaea (diff) | |
| download | postgresql-534874fac0b34535c9a5ab9257d6574f78423578.tar.gz postgresql-534874fac0b34535c9a5ab9257d6574f78423578.zip | |
Allow "COPY table TO" command to copy rows from materialized views.
Previously, "COPY table TO" command worked only with plain tables and
did not support materialized views, even when they were populated and
had physical storage. To copy rows from materialized views,
"COPY (query) TO" command had to be used, instead.
This commit extends "COPY table TO" to support populated materialized
views directly, improving usability and performance, as "COPY table TO"
is generally faster than "COPY (query) TO". Note that copying from
unpopulated materialized views will still result in an error.
Author: jian he <jian.universality@gmail.com>
Reviewed-by: Kirill Reshke <reshkekirill@gmail.com>
Reviewed-by: David G. Johnston <david.g.johnston@gmail.com>
Reviewed-by: Vignesh C <vignesh21@gmail.com>
Reviewed-by: Fujii Masao <masao.fujii@gmail.com>
Discussion: https://postgr.es/m/CACJufxHVxnyRYy67hiPePNCPwVBMzhTQ6FaL9_Te5On9udG=yg@mail.gmail.com
Diffstat (limited to 'doc/src')
| -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> |