Home Explore Blog CI



postgresql

58th chunk of `doc/src/sgml/information_schema.sgml`
936c796b62d2be92b3cb9cb944cd3547db197076d1e4f8420000000100000fa8
 </thead>

    <tbody>
     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>specific_catalog</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the database containing the function (always the current database)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>specific_schema</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the schema containing the function
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>specific_name</structfield> <type>sql_identifier</type>
      </para>
      <para>
       The <quote>specific name</quote> of the function.  See <xref linkend="infoschema-routines"/> for more information.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>routine_catalog</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the database containing the function (always the current database)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>routine_schema</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the schema containing the function
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>routine_name</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the function (might be duplicated in case of overloading)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>schema_catalog</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the database that contains the sequence that is used by the
       function (always the current database)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>sequence_schema</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the schema that contains the sequence that is used by the function
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>sequence_name</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the sequence that is used by the function
      </para></entry>
     </row>
    </tbody>
   </tgroup>
  </table>
 </sect1>

 <sect1 id="infoschema-routine-table-usage">
  <title><literal>routine_table_usage</literal></title>

  <para>
   The view <literal>routine_table_usage</literal> is meant to identify all
   tables that are used by a function or procedure.  This information is
   currently not tracked by <productname>PostgreSQL</productname>.
  </para>

  <table>
   <title><literal>routine_table_usage</literal> 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>specific_catalog</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the database containing the function (always the current database)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>specific_schema</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the schema containing the function
      </para></entry>

Title: Information Schema: Routine Table and Sequence Usage Views
Summary
This section describes the 'routine_table_usage' and 'routine_sequence_usage' views, detailing the columns and descriptions for tracking tables and sequences used by functions or procedures, including database, schema, and specific names, although 'routine_table_usage' is noted as not being currently tracked by PostgreSQL.