begriffs open source - ai-pg/blob - full-docs/src/sgml/html/catalog-pg-transform.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.57. pg_transform</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-tablespace.html" title="52.56. pg_tablespace" /><link rel="next" href="catalog-pg-trigger.html" title="52.58. pg_trigger" /></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.57. <code class="structname">pg_transform</code></th></tr><tr><td width="10%" align="left"><a accesskey="p" href="catalog-pg-tablespace.html" title="52.56. pg_tablespace">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-trigger.html" title="52.58. pg_trigger">Next</a></td></tr></table><hr /></div><div class="sect1" id="CATALOG-PG-TRANSFORM"><div class="titlepage"><div><div><h2 class="title" style="clear: both">52.57. <code class="structname">pg_transform</code> <a href="#CATALOG-PG-TRANSFORM" class="id_link">#</a></h2></div></div></div><a id="id-1.10.4.59.2" class="indexterm"></a><p>
   3    The catalog <code class="structname">pg_transform</code> stores information about
   4    transforms, which are a mechanism to adapt data types to procedural
   5    languages.  See <a class="xref" href="sql-createtransform.html" title="CREATE TRANSFORM"><span class="refentrytitle">CREATE TRANSFORM</span></a> for more information.
   6   </p><div class="table" id="id-1.10.4.59.4"><p class="title"><strong>Table 52.57. <code class="structname">pg_transform</code> Columns</strong></p><div class="table-contents"><table class="table" summary="pg_transform Columns" border="1"><colgroup><col /></colgroup><thead><tr><th class="catalog_table_entry"><p class="column_definition">
   7        Column Type
   8       </p>
   9       <p>
  10        Description
  11       </p></th></tr></thead><tbody><tr><td class="catalog_table_entry"><p class="column_definition">
  12        <code class="structfield">oid</code> <code class="type">oid</code>
  13       </p>
  14       <p>
  15        Row identifier
  16       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  17        <code class="structfield">trftype</code> <code class="type">oid</code>
  18        (references <a class="link" href="catalog-pg-type.html" title="52.64. pg_type"><code class="structname">pg_type</code></a>.<code class="structfield">oid</code>)
  19       </p>
  20       <p>
  21        OID of the data type this transform is for
  22       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  23        <code class="structfield">trflang</code> <code class="type">oid</code>
  24        (references <a class="link" href="catalog-pg-language.html" title="52.29. pg_language"><code class="structname">pg_language</code></a>.<code class="structfield">oid</code>)
  25       </p>
  26       <p>
  27        OID of the language this transform is for
  28       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  29        <code class="structfield">trffromsql</code> <code class="type">regproc</code>
  30        (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>)
  31       </p>
  32       <p>
  33        The OID of the function to use when converting the data type for input
  34        to the procedural language (e.g., function parameters).  Zero is stored
  35        if the default behavior should be used.
  36       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  37        <code class="structfield">trftosql</code> <code class="type">regproc</code>
  38        (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>)
  39       </p>
  40       <p>
  41        The OID of the function to use when converting output from the
  42        procedural language (e.g., return values) to the data type.  Zero is
  43        stored if the default behavior should be used.
  44       </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-tablespace.html" title="52.56. pg_tablespace">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-trigger.html" title="52.58. pg_trigger">Next</a></td></tr><tr><td width="40%" align="left" valign="top">52.56. <code class="structname">pg_tablespace</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.58. <code class="structname">pg_trigger</code></td></tr></table></div></body></html>