diff options
| author | Amit Kapila <akapila@postgresql.org> | 2025-04-29 09:01:43 +0530 |
|---|---|---|
| committer | Amit Kapila <akapila@postgresql.org> | 2025-04-29 09:01:43 +0530 |
| commit | 9807617a9293f3fce867fbde99e0840cb5695a12 (patch) | |
| tree | 116376a7a069a343ee2006b4e0189afeadd171a2 /doc/src | |
| parent | f132815fd717f26613dcc3888608044eac91a7ac (diff) | |
| download | postgresql-9807617a9293f3fce867fbde99e0840cb5695a12.tar.gz postgresql-9807617a9293f3fce867fbde99e0840cb5695a12.zip | |
Doc: Specify the interaction of publish_generated_columns with column list.
Author: Peter Smith <smithpb2250@gmail.com>
Reviewed-by: David G. Johnston <david.g.johnston@gmail.com>
Reviewed-by: Amit Kapila <amit.kapila16@gmail.com>
Discussion: https://postgr.es/m/CAHut+PtnjLiNFFh-3f9cXH0wnwqjdkTjQNbVmZdZ1y+zKt_PPg@mail.gmail.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/create_publication.sgml | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/doc/src/sgml/ref/create_publication.sgml b/doc/src/sgml/ref/create_publication.sgml index 73f0c8d89fb..802630f2df1 100644 --- a/doc/src/sgml/ref/create_publication.sgml +++ b/doc/src/sgml/ref/create_publication.sgml @@ -89,10 +89,12 @@ CREATE PUBLICATION <replaceable class="parameter">name</replaceable> <para> When a column list is specified, only the named columns are replicated. - The column list can contain stored generated columns as well. If no - column list is specified, all table columns (except generated columns) - are replicated through this publication, including any columns added - later. It has no effect on <literal>TRUNCATE</literal> commands. See + The column list can contain stored generated columns as well. If the + column list is omitted, the publication will replicate all non-generated + columns (including any added in the future) by default. Stored generated + columns can also be replicated if <literal>publish_generated_columns</literal> + is set to <literal>stored</literal>. Specifying a column list has no + effect on <literal>TRUNCATE</literal> commands. See <xref linkend="logical-replication-col-lists"/> for details about column lists. </para> |