Home Explore Blog CI



postgresql

75th chunk of `doc/src/sgml/catalogs.sgml`
694471d7ef666cfb8e636a3e76a9a2c70e75818c68cafd0a0000000100000fb7
 Columns</title>
   <tgroup cols="1">
    <thead>
     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       Column Type
      </para>
      <para>
       Description
      </para></entry>
     </row>
    </thead>

    <tbody>
     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>oid</structfield> <type>oid</type>
      </para>
      <para>
       Row identifier
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>pubname</structfield> <type>name</type>
      </para>
      <para>
       Name of the publication
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>pubowner</structfield> <type>oid</type>
       (references <link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.<structfield>oid</structfield>)
      </para>
      <para>
       Owner of the publication
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>puballtables</structfield> <type>bool</type>
      </para>
      <para>
       If true, this publication automatically includes all tables
       in the database, including any that will be created in the future.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>pubinsert</structfield> <type>bool</type>
      </para>
      <para>
       If true, <xref linkend="sql-insert"/> operations are replicated for
       tables in the publication.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>pubupdate</structfield> <type>bool</type>
      </para>
      <para>
       If true, <xref linkend="sql-update"/> operations are replicated for
       tables in the publication.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>pubdelete</structfield> <type>bool</type>
      </para>
      <para>
       If true, <xref linkend="sql-delete"/> operations are replicated for
       tables in the publication.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>pubtruncate</structfield> <type>bool</type>
      </para>
      <para>
       If true, <xref linkend="sql-truncate"/> operations are replicated for
       tables in the publication.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>pubviaroot</structfield> <type>bool</type>
      </para>
      <para>
       If true, operations on a leaf partition are replicated using the
       identity and schema of its topmost partitioned ancestor mentioned in the
       publication instead of its own.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>pubgencols</structfield> <type>char</type>
      </para>
      <para>
       Controls how to handle generated column replication when there is no
       publication column list:
       <literal>n</literal> = generated columns in the tables associated with
       the publication should not be replicated,
       <literal>s</literal> = stored generated columns in the tables associated
       with the publication should be replicated.
      </para></entry>
     </row>
    </tbody>
   </tgroup>
  </table>
 </sect1>

 <sect1 id="catalog-pg-publication-namespace">
  <title><structname>pg_publication_namespace</structname></title>

  <indexterm zone="catalog-pg-publication-namespace">
   <primary>pg_publication_namespace</primary>
  </indexterm>

  <para>
   The catalog <structname>pg_publication_namespace</structname>

Title: pg_publication Columns: Owner, All Tables Flag, Replication Flags, and Generated Column Handling
Summary
This section describes the columns of the `pg_publication` catalog, including `pubowner` (owner of the publication), `puballtables` (indicates if all tables are automatically included), `pubinsert`, `pubupdate`, `pubdelete`, and `pubtruncate` (flags indicating which operations are replicated), `pubviaroot` (specifies if operations on leaf partitions are replicated using the identity and schema of the topmost partitioned ancestor), and `pubgencols` (controls how generated column replication is handled). It then introduces the `pg_publication_namespace` catalog.