Home Explore Blog CI



postgresql

72th chunk of `doc/src/sgml/information_schema.sgml`
e405d0bab3e127fba03f46cfb4ecea8782be80b52fd415b80000000100000fcb
 <type>yes_or_no</type>
      </para>
      <para>
       <literal>YES</literal> if the sequence cycles, else <literal>NO</literal>
      </para></entry>
     </row>
    </tbody>
   </tgroup>
  </table>

  <para>
   Note that in accordance with the SQL standard, the start, minimum,
   maximum, and increment values are returned as character strings.
  </para>
 </sect1>

 <sect1 id="infoschema-sql-features">
  <title><literal>sql_features</literal></title>

  <para>
   The table <literal>sql_features</literal> contains information
   about which formal features defined in the SQL standard are
   supported by <productname>PostgreSQL</productname>.  This is the
   same information that is presented in <xref linkend="features"/>.
   There you can also find some additional background information.
  </para>

  <table>
   <title><structname>sql_features</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>
       Identifier string of the feature
      </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 feature
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>sub_feature_id</structfield> <type>character_data</type>
      </para>
      <para>
       Identifier string of the subfeature, or a zero-length string if not a subfeature
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>sub_feature_name</structfield> <type>character_data</type>
      </para>
      <para>
       Descriptive name of the subfeature, or a zero-length string if not a subfeature
      </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 feature 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 feature
      </para></entry>
     </row>
    </tbody>
   </tgroup>
  </table>
 </sect1>

 <sect1 id="infoschema-sql-implementation-info">
  <title><literal>sql_implementation_info</literal></title>

  <para>
   The table <literal>sql_implementation_info</literal> contains
   information about various aspects that are left
   implementation-defined by the SQL standard.  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 implementation
   information items are not described here; you will find them in the
   description of the ODBC interface.
  </para>

  <table>
   <title><structname>sql_implementation_info</structname>

Title: Information Schema: SQL Features and Implementation Info
Summary
This section describes the sql_features and sql_implementation_info views in the information schema, which contain information about the SQL standard features supported by PostgreSQL and implementation-defined aspects of the SQL standard, including feature identifiers, names, support status, and comments.