Home Explore Blog CI



postgresql

45th chunk of `doc/src/sgml/information_schema.sgml`
6c20115faa9f4af5f8513207c32cca27a1a420994b3d435f0000000100000fa4
 applied to parameter 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 parameter 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 parameter 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 parameter 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 parameter 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 parameter 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 parameter 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 parameter data types in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

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

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>udt_catalog</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the database that the data type of the parameter is
       defined in (always the current database)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>udt_schema</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the schema that the data type of the parameter is
       defined in
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>udt_name</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the data type of the parameter
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>scope_catalog</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Applies to a feature

Title: Information Schema: Parameters View Columns (Continued)
Summary
This section continues to describe the columns in the 'parameters' view, including numeric precision, interval type, and user-defined type attributes, with many columns being null or not applicable in PostgreSQL, while others provide information about the parameter's data type and schema.