Home Explore Blog CI



postgresql

74th chunk of `doc/src/sgml/information_schema.sgml`
32d6869d013690e10fa0635072d1dbb06cb91fecc7a3e69c0000000100000fa0
 <title><literal>sql_parts</literal></title>

  <para>
   The table <literal>sql_parts</literal> contains information about
   which of the several parts of the SQL standard are supported by
   <productname>PostgreSQL</productname>.
  </para>

  <table>
   <title><structname>sql_parts</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>feature_id</structfield> <type>character_data</type>
      </para>
      <para>
       An identifier string containing the number of the part
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>feature_name</structfield> <type>character_data</type>
      </para>
      <para>
       Descriptive name of the part
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>is_supported</structfield> <type>yes_or_no</type>
      </para>
      <para>
       <literal>YES</literal> if the part is fully supported by the
       current version of <productname>PostgreSQL</productname>,
       <literal>NO</literal> if not
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>is_verified_by</structfield> <type>character_data</type>
      </para>
      <para>
       Always null, since the <productname>PostgreSQL</productname> development group does not
       perform formal testing of feature conformance
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>comments</structfield> <type>character_data</type>
      </para>
      <para>
       Possibly a comment about the supported status of the part
      </para></entry>
     </row>
    </tbody>
   </tgroup>
  </table>
 </sect1>

 <sect1 id="infoschema-sql-sizing">
  <title><literal>sql_sizing</literal></title>

  <para>
   The table <literal>sql_sizing</literal> contains information about
   various size limits and maximum values in
   <productname>PostgreSQL</productname>.  This information is
   primarily intended for use in the context of the ODBC interface;
   users of other interfaces will probably find this information to be
   of little use.  For this reason, the individual sizing items are
   not described here; you will find them in the description of the
   ODBC interface.
  </para>

  <table>
   <title><structname>sql_sizing</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>sizing_id</structfield> <type>cardinal_number</type>
      </para>
      <para>
       Identifier of the sizing item
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>sizing_name</structfield> <type>character_data</type>
      </para>
      <para>
       Descriptive name of the sizing item
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>supported_value</structfield> <type>cardinal_number</type>
      </para>
      <para>
       Value of the sizing item, or 0 if the size is unlimited or
       cannot be determined, or null if the features for which the
       sizing item is applicable are not supported
      </para></entry>
     </row>

     <row>
 

Title: Information Schema: SQL Parts and Sizing
Summary
This section describes the sql_parts and sql_sizing tables in the information schema, which contain information about the parts of the SQL standard supported by PostgreSQL and size limits and maximum values in PostgreSQL, including feature identifiers, names, support status, and sizing item values.