codekingpro/portable-devtools

1<?xml version="1.0" encoding="UTF-8" standalone="no"?>2<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>37.42. routine_routine_usage</title><link rel="stylesheet" type="text/css" href="stylesheet.css" /><link rev="made" href="pgsql-docs@lists.postgresql.org" /><meta name="generator" content="DocBook XSL Stylesheets Vsnapshot" /><link rel="prev" href="infoschema-routine-privileges.html" title="37.41. routine_privileges" /><link rel="next" href="infoschema-routine-sequence-usage.html" title="37.43. routine_sequence_usage" /></head><body id="docContent" class="container-fluid col-10"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="5" align="center">37.42. <code class="literal">routine_routine_usage</code></th></tr><tr><td width="10%" align="left"><a accesskey="p" href="infoschema-routine-privileges.html" title="37.41. routine_privileges">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="information-schema.html" title="Chapter 37. The Information Schema">Up</a></td><th width="60%" align="center">Chapter 37. The Information Schema</th><td width="10%" align="right"><a accesskey="h" href="index.html" title="PostgreSQL 16.3 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="infoschema-routine-sequence-usage.html" title="37.43. routine_sequence_usage">Next</a></td></tr></table><hr /></div><div class="sect1" id="INFOSCHEMA-ROUTINE-ROUTINE-USAGE"><div class="titlepage"><div><div><h2 class="title" style="clear: both">37.42. <code class="literal">routine_routine_usage</code> <a href="#INFOSCHEMA-ROUTINE-ROUTINE-USAGE" class="id_link">#</a></h2></div></div></div><p>3   The view <code class="literal">routine_routine_usage</code> identifies all functions4   or procedures that are used by another (or the same) function or procedure,5   either in the SQL body or in parameter default expressions.  (This only6   works for unquoted SQL bodies, not quoted bodies or functions in other7   languages.)  An entry is included here only if the used function is owned8   by a currently enabled role.  (There is no such restriction on the using9   function.)10  </p><p>11   Note that the entries for both functions in the view refer to the12   <span class="quote">“<span class="quote">specific</span>”</span> name of the routine, even though the column names13   are used in a way that is inconsistent with other information schema views14   about routines.  This is per SQL standard, although it is arguably a15   misdesign.  See <a class="xref" href="infoschema-routines.html" title="37.45. routines">Section 37.45</a> for more information16   about specific names.17  </p><div class="table" id="id-1.7.6.46.4"><p class="title"><strong>Table 37.40. <code class="literal">routine_routine_usage</code> Columns</strong></p><div class="table-contents"><table class="table" summary="routine_routine_usage Columns" border="1"><colgroup><col /></colgroup><thead><tr><th class="catalog_table_entry"><p class="column_definition">18       Column Type19      </p>20      <p>21       Description22      </p></th></tr></thead><tbody><tr><td class="catalog_table_entry"><p class="column_definition">23       <code class="structfield">specific_catalog</code> <code class="type">sql_identifier</code>24      </p>25      <p>26       Name of the database containing the using function (always the current database)27      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">28       <code class="structfield">specific_schema</code> <code class="type">sql_identifier</code>29      </p>30      <p>31       Name of the schema containing the using function32      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">33       <code class="structfield">specific_name</code> <code class="type">sql_identifier</code>34      </p>35      <p>36       The <span class="quote">“<span class="quote">specific name</span>”</span> of the using function.37      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">38       <code class="structfield">routine_catalog</code> <code class="type">sql_identifier</code>39      </p>40      <p>41       Name of the database that contains the function that is used by the42       first function (always the current database)43      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">44       <code class="structfield">routine_schema</code> <code class="type">sql_identifier</code>45      </p>46      <p>47       Name of the schema that contains the function that is used by the first48       function49      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">50       <code class="structfield">routine_name</code> <code class="type">sql_identifier</code>51      </p>52      <p>53       The <span class="quote">“<span class="quote">specific name</span>”</span> of the function that is used by the54       first function.55      </p></td></tr></tbody></table></div></div><br class="table-break" /></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="infoschema-routine-privileges.html" title="37.41. routine_privileges">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="information-schema.html" title="Chapter 37. The Information Schema">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="infoschema-routine-sequence-usage.html" title="37.43. routine_sequence_usage">Next</a></td></tr><tr><td width="40%" align="left" valign="top">37.41. <code class="literal">routine_privileges</code> </td><td width="20%" align="center"><a accesskey="h" href="index.html" title="PostgreSQL 16.3 Documentation">Home</a></td><td width="40%" align="right" valign="top"> 37.43. <code class="literal">routine_sequence_usage</code></td></tr></table></div></body></html>