Home Explore Blog CI



postgresql

76th chunk of `doc/src/sgml/catalogs.sgml`
2e1cec122c67600d3faecfa325eeed19e71795da48d1d5a60000000100000fa3

       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> contains the
   mapping between schemas and publications in the database.  This is a
   many-to-many mapping.
  </para>

  <table>
   <title><structname>pg_publication_namespace</structname> 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>pnpubid</structfield> <type>oid</type>
       (references <link linkend="catalog-pg-publication"><structname>pg_publication</structname></link>.<structfield>oid</structfield>)
      </para>
      <para>
       Reference to publication
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>pnnspid</structfield> <type>oid</type>
       (references <link linkend="catalog-pg-namespace"><structname>pg_namespace</structname></link>.<structfield>oid</structfield>)
      </para>
      <para>
       Reference to schema
      </para></entry>
     </row>
    </tbody>
   </tgroup>
  </table>
 </sect1>

 <sect1 id="catalog-pg-publication-rel">
  <title><structname>pg_publication_rel</structname></title>

  <indexterm zone="catalog-pg-publication-rel">
   <primary>pg_publication_rel</primary>
  </indexterm>

  <para>
   The catalog <structname>pg_publication_rel</structname> contains the
   mapping between relations and publications in the database.  This is a
   many-to-many mapping.  See also <xref linkend="view-pg-publication-tables"/>
   for a more user-friendly view of this information.
  </para>

  <table>
   <title><structname>pg_publication_rel</structname> 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>prpubid</structfield> <type>oid</type>
       (references <link linkend="catalog-pg-publication"><structname>pg_publication</structname></link>.<structfield>oid</structfield>)
      </para>
      <para>
       Reference to publication
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>prrelid</structfield>

Title: pg_publication_namespace and pg_publication_rel Catalogs: Schema-Publication and Relation-Publication Mappings
Summary
This section describes the `pg_publication_namespace` catalog, which maps schemas to publications, and its columns: `oid`, `pnpubid` (reference to publication), and `pnnspid` (reference to schema). It then describes the `pg_publication_rel` catalog, which maps relations to publications, and its columns: `oid`, `prpubid` (reference to publication), and `prrelid` (reference to relation). A user-friendly view of the information in `pg_publication_rel` is available through `pg_publication_tables`.