Home Explore Blog CI



postgresql

66th chunk of `doc/src/sgml/catalogs.sgml`
34e63a95cbe341f86d7c3090e39422755be4146ac99555420000000100000fa0
     </row>
    </tbody>
   </tgroup>
  </table>

  <para>
   The majority of the information defining an operator family is not in its
   <structname>pg_opfamily</structname> row, but in the associated rows in
   <link linkend="catalog-pg-amop"><structname>pg_amop</structname></link>,
   <link linkend="catalog-pg-amproc"><structname>pg_amproc</structname></link>,
   and
   <link linkend="catalog-pg-opclass"><structname>pg_opclass</structname></link>.
  </para>

 </sect1>


 <sect1 id="catalog-pg-parameter-acl">
  <title><structname>pg_parameter_acl</structname></title>

  <indexterm zone="catalog-pg-parameter-acl">
   <primary>pg_parameter_acl</primary>
  </indexterm>

  <para>
   The catalog <structname>pg_parameter_acl</structname> records configuration
   parameters for which privileges have been granted to one or more roles.
   No entry is made for parameters that have default privileges.
  </para>

  <para>
   Unlike most system catalogs, <structname>pg_parameter_acl</structname>
   is shared across all databases of a cluster: there is only one
   copy of <structname>pg_parameter_acl</structname> per cluster, not
   one per database.
  </para>

  <table>
   <title><structname>pg_parameter_acl</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>parname</structfield> <type>text</type>
      </para>
      <para>
       The name of a configuration parameter for which privileges are granted
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>paracl</structfield> <type>aclitem[]</type>
      </para>
      <para>
       Access privileges; see <xref linkend="ddl-priv"/> for details
      </para></entry>
     </row>

    </tbody>
   </tgroup>
  </table>
 </sect1>


 <sect1 id="catalog-pg-partitioned-table">
  <title><structname>pg_partitioned_table</structname></title>

  <indexterm zone="catalog-pg-partitioned-table">
   <primary>pg_partitioned_table</primary>
  </indexterm>

  <para>
   The catalog <structname>pg_partitioned_table</structname> stores
   information about how tables are partitioned.
  </para>

  <table>
   <title><structname>pg_partitioned_table</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>partrelid</structfield> <type>oid</type>
       (references <link linkend="catalog-pg-class"><structname>pg_class</structname></link>.<structfield>oid</structfield>)
      </para>
      <para>
       The OID of the <link linkend="catalog-pg-class"><structname>pg_class</structname></link> entry for this partitioned table
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>partstrat</structfield> <type>char</type>
      </para>
      <para>
       Partitioning strategy; <literal>h</literal> = hash partitioned table,
       <literal>l</literal> = list partitioned table, <literal>r</literal> = range partitioned table
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>partnatts</structfield> <type>int2</type>
      </para>

Title: pg_parameter_acl and pg_partitioned_table Catalogs
Summary
This section describes the `pg_parameter_acl` and `pg_partitioned_table` catalogs. `pg_parameter_acl` records configuration parameters with granted privileges, excluding those with default privileges, and is shared across all databases in a cluster. The columns of `pg_parameter_acl` are described, including `oid`, `parname`, and `paracl`. Next, the `pg_partitioned_table` catalog is introduced, storing information on how tables are partitioned. The catalog's columns are detailed, including `partrelid`, `partstrat`, and `partnatts`.