<title><structname>pg_subscription</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>subdbid</structfield> <type>oid</type>
       (references <link linkend="catalog-pg-database"><structname>pg_database</structname></link>.<structfield>oid</structfield>)
      </para>
      <para>
       OID of the database that the subscription resides in
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>subskiplsn</structfield> <type>pg_lsn</type>
      </para>
      <para>
       Finish LSN of the transaction whose changes are to be skipped, if a valid
       LSN; otherwise <literal>0/0</literal>.
      </para></entry>
     </row>

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

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

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>subenabled</structfield> <type>bool</type>
      </para>
      <para>
       If true, the subscription is enabled and should be replicating
      </para></entry>
     </row>

    <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>subbinary</structfield> <type>bool</type>
      </para>
      <para>
       If true, the subscription will request that the publisher send data
       in binary format
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>substream</structfield> <type>char</type>
      </para>
      <para>
       Controls how to handle the streaming of in-progress transactions:
       <literal>f</literal> = disallow streaming of in-progress transactions,
       <literal>t</literal> = spill the changes of in-progress transactions to
       disk and apply at once after the transaction is committed on the
       publisher and received by the subscriber,
       <literal>p</literal> = apply changes directly using a parallel apply
       worker if available (same as <literal>t</literal> if no worker is
       available)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>subtwophasestate</structfield> <type>char</type>
      </para>
      <para>
       State codes for two-phase mode:
       <literal>d</literal> = disabled,
       <literal>p</literal> = pending enablement,
       <literal>e</literal> = enabled
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>subdisableonerr</structfield> <type>bool</type>
      </para>
      <para>
       If true, the subscription will be disabled if one of its workers
       detects an error
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>subpasswordrequired</structfield> <type>bool</type>