Home Explore Blog CI



postgresql

62th chunk of `doc/src/sgml/information_schema.sgml`
6690c9bcf4f044cbe71641f462a17688867074f4ec0799be0000000100000fa0
 role="column_definition">
       <structfield>character_octet_length</structfield> <type>cardinal_number</type>
      </para>
      <para>
       Always null, since this information is not applied to return data types in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>character_set_catalog</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Applies to a feature not available in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>character_set_schema</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Applies to a feature not available in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>character_set_name</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Applies to a feature not available in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>collation_catalog</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Always null, since this information is not applied to return data types in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>collation_schema</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Always null, since this information is not applied to return data types in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>collation_name</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Always null, since this information is not applied to return data types in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>numeric_precision</structfield> <type>cardinal_number</type>
      </para>
      <para>
       Always null, since this information is not applied to return data types in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>numeric_precision_radix</structfield> <type>cardinal_number</type>
      </para>
      <para>
       Always null, since this information is not applied to return data types in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>numeric_scale</structfield> <type>cardinal_number</type>
      </para>
      <para>
       Always null, since this information is not applied to return data types in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>datetime_precision</structfield> <type>cardinal_number</type>
      </para>
      <para>
       Always null, since this information is not applied to return data types in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>interval_type</structfield> <type>character_data</type>
      </para>
      <para>
       Always null, since this information is not applied to return data types in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
   

Title: Information Schema: Routines View Columns Continued
Summary
This section further describes columns of the 'routines' view in PostgreSQL, detailing character set, collation, and numeric properties, with most columns containing null values as the corresponding information is not applicable to return data types in PostgreSQL.