begriffs open source - ai-pg/blob - full-docs/src/sgml/html/catalog-pg-language.html

   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>52.29. pg_language</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="catalog-pg-init-privs.html" title="52.28. pg_init_privs" /><link rel="next" href="catalog-pg-largeobject.html" title="52.30. pg_largeobject" /></head><body id="docContent" class="container-fluid col-10"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="5" align="center">52.29. <code class="structname">pg_language</code></th></tr><tr><td width="10%" align="left"><a accesskey="p" href="catalog-pg-init-privs.html" title="52.28. pg_init_privs">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="catalogs.html" title="Chapter 52. System Catalogs">Up</a></td><th width="60%" align="center">Chapter 52. System Catalogs</th><td width="10%" align="right"><a accesskey="h" href="index.html" title="PostgreSQL 18.0 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="catalog-pg-largeobject.html" title="52.30. pg_largeobject">Next</a></td></tr></table><hr /></div><div class="sect1" id="CATALOG-PG-LANGUAGE"><div class="titlepage"><div><div><h2 class="title" style="clear: both">52.29. <code class="structname">pg_language</code> <a href="#CATALOG-PG-LANGUAGE" class="id_link">#</a></h2></div></div></div><a id="id-1.10.4.31.2" class="indexterm"></a><p>
   3    The catalog <code class="structname">pg_language</code> registers
   4    languages in which you can write functions or stored procedures.
   5    See <a class="xref" href="sql-createlanguage.html" title="CREATE LANGUAGE"><span class="refentrytitle">CREATE LANGUAGE</span></a>
   6    and <a class="xref" href="xplang.html" title="Chapter 40. Procedural Languages">Chapter 40</a> for more information about language handlers.
   7   </p><div class="table" id="id-1.10.4.31.4"><p class="title"><strong>Table 52.29. <code class="structname">pg_language</code> Columns</strong></p><div class="table-contents"><table class="table" summary="pg_language Columns" border="1"><colgroup><col /></colgroup><thead><tr><th class="catalog_table_entry"><p class="column_definition">
   8        Column Type
   9       </p>
  10       <p>
  11        Description
  12       </p></th></tr></thead><tbody><tr><td class="catalog_table_entry"><p class="column_definition">
  13        <code class="structfield">oid</code> <code class="type">oid</code>
  14       </p>
  15       <p>
  16        Row identifier
  17       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  18        <code class="structfield">lanname</code> <code class="type">name</code>
  19       </p>
  20       <p>
  21        Name of the language
  22       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  23        <code class="structfield">lanowner</code> <code class="type">oid</code>
  24        (references <a class="link" href="catalog-pg-authid.html" title="52.8. pg_authid"><code class="structname">pg_authid</code></a>.<code class="structfield">oid</code>)
  25       </p>
  26       <p>
  27        Owner of the language
  28       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  29        <code class="structfield">lanispl</code> <code class="type">bool</code>
  30       </p>
  31       <p>
  32        This is false for internal languages (such as
  33        <acronym class="acronym">SQL</acronym>) and true for user-defined languages.
  34        Currently, <span class="application">pg_dump</span> still uses this
  35        to determine which languages need to be dumped, but this might be
  36        replaced by a different mechanism in the future.
  37       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  38        <code class="structfield">lanpltrusted</code> <code class="type">bool</code>
  39       </p>
  40       <p>
  41        True if this is a trusted language, which means that it is believed
  42        not to grant access to anything outside the normal SQL execution
  43        environment.  Only superusers can create functions in untrusted
  44        languages.
  45       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  46        <code class="structfield">lanplcallfoid</code> <code class="type">oid</code>
  47        (references <a class="link" href="catalog-pg-proc.html" title="52.39. pg_proc"><code class="structname">pg_proc</code></a>.<code class="structfield">oid</code>)
  48       </p>
  49       <p>
  50        For noninternal languages this references the language
  51        handler, which is a special function that is responsible for
  52        executing all functions that are written in the particular
  53        language. Zero for internal languages.
  54       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  55        <code class="structfield">laninline</code> <code class="type">oid</code>
  56        (references <a class="link" href="catalog-pg-proc.html" title="52.39. pg_proc"><code class="structname">pg_proc</code></a>.<code class="structfield">oid</code>)
  57       </p>
  58       <p>
  59        This references a function that is responsible for executing
  60        <span class="quote">“<span class="quote">inline</span>”</span> anonymous code blocks
  61        (<a class="xref" href="sql-do.html" title="DO"><span class="refentrytitle">DO</span></a> blocks).
  62        Zero if inline blocks are not supported.
  63       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  64        <code class="structfield">lanvalidator</code> <code class="type">oid</code>
  65        (references <a class="link" href="catalog-pg-proc.html" title="52.39. pg_proc"><code class="structname">pg_proc</code></a>.<code class="structfield">oid</code>)
  66       </p>
  67       <p>
  68        This references a language validator function that is responsible
  69        for checking the syntax and validity of new functions when they
  70        are created.  Zero if no validator is provided.
  71       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  72        <code class="structfield">lanacl</code> <code class="type">aclitem[]</code>
  73       </p>
  74       <p>
  75        Access privileges; see <a class="xref" href="ddl-priv.html" title="5.8. Privileges">Section 5.8</a> for details
  76       </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="catalog-pg-init-privs.html" title="52.28. pg_init_privs">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="catalogs.html" title="Chapter 52. System Catalogs">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="catalog-pg-largeobject.html" title="52.30. pg_largeobject">Next</a></td></tr><tr><td width="40%" align="left" valign="top">52.28. <code class="structname">pg_init_privs</code> </td><td width="20%" align="center"><a accesskey="h" href="index.html" title="PostgreSQL 18.0 Documentation">Home</a></td><td width="40%" align="right" valign="top"> 52.30. <code class="structname">pg_largeobject</code></td></tr></table></div></body></html>