begriffs open source - ai-pg/blob - full-docs/html/infoschema-user-defined-types.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>35.60. user_defined_types</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-usage-privileges.html" title="35.59. usage_privileges" /><link rel="next" href="infoschema-user-mapping-options.html" title="35.61. user_mapping_options" /></head><body id="docContent" class="container-fluid col-10"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="5" align="center">35.60. <code class="literal">user_defined_types</code></th></tr><tr><td width="10%" align="left"><a accesskey="p" href="infoschema-usage-privileges.html" title="35.59. usage_privileges">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="information-schema.html" title="Chapter 35. The Information Schema">Up</a></td><th width="60%" align="center">Chapter 35. The Information Schema</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="infoschema-user-mapping-options.html" title="35.61. user_mapping_options">Next</a></td></tr></table><hr /></div><div class="sect1" id="INFOSCHEMA-USER-DEFINED-TYPES"><div class="titlepage"><div><div><h2 class="title" style="clear: both">35.60. <code class="literal">user_defined_types</code> <a href="#INFOSCHEMA-USER-DEFINED-TYPES" class="id_link">#</a></h2></div></div></div><p>
   3    The view <code class="literal">user_defined_types</code> currently contains
   4    all composite types defined in the current database.
   5    Only those types are shown that the current user has access to (by way
   6    of being the owner or having some privilege).
   7   </p><p>
   8    SQL knows about two kinds of user-defined types: structured types
   9    (also known as composite types
  10    in <span class="productname">PostgreSQL</span>) and distinct types (not
  11    implemented in <span class="productname">PostgreSQL</span>).  To be
  12    future-proof, use the
  13    column <code class="literal">user_defined_type_category</code> to
  14    differentiate between these.  Other user-defined types such as base
  15    types and enums, which are <span class="productname">PostgreSQL</span>
  16    extensions, are not shown here.  For domains,
  17    see <a class="xref" href="infoschema-domains.html" title="35.23. domains">Section 35.23</a> instead.
  18   </p><div class="table" id="id-1.7.6.64.4"><p class="title"><strong>Table 35.58. <code class="structname">user_defined_types</code> Columns</strong></p><div class="table-contents"><table class="table" summary="user_defined_types Columns" border="1"><colgroup><col /></colgroup><thead><tr><th class="catalog_table_entry"><p class="column_definition">
  19        Column Type
  20       </p>
  21       <p>
  22        Description
  23       </p></th></tr></thead><tbody><tr><td class="catalog_table_entry"><p class="column_definition">
  24        <code class="structfield">user_defined_type_catalog</code> <code class="type">sql_identifier</code>
  25       </p>
  26       <p>
  27        Name of the database that contains the type (always the current database)
  28       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  29        <code class="structfield">user_defined_type_schema</code> <code class="type">sql_identifier</code>
  30       </p>
  31       <p>
  32        Name of the schema that contains the type
  33       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  34        <code class="structfield">user_defined_type_name</code> <code class="type">sql_identifier</code>
  35       </p>
  36       <p>
  37        Name of the type
  38       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  39        <code class="structfield">user_defined_type_category</code> <code class="type">character_data</code>
  40       </p>
  41       <p>
  42        Currently always <code class="literal">STRUCTURED</code>
  43       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  44        <code class="structfield">is_instantiable</code> <code class="type">yes_or_no</code>
  45       </p>
  46       <p>
  47        Applies to a feature not available in <span class="productname">PostgreSQL</span>
  48       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  49        <code class="structfield">is_final</code> <code class="type">yes_or_no</code>
  50       </p>
  51       <p>
  52        Applies to a feature not available in <span class="productname">PostgreSQL</span>
  53       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  54        <code class="structfield">ordering_form</code> <code class="type">character_data</code>
  55       </p>
  56       <p>
  57        Applies to a feature not available in <span class="productname">PostgreSQL</span>
  58       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  59        <code class="structfield">ordering_category</code> <code class="type">character_data</code>
  60       </p>
  61       <p>
  62        Applies to a feature not available in <span class="productname">PostgreSQL</span>
  63       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  64        <code class="structfield">ordering_routine_catalog</code> <code class="type">sql_identifier</code>
  65       </p>
  66       <p>
  67        Applies to a feature not available in <span class="productname">PostgreSQL</span>
  68       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  69        <code class="structfield">ordering_routine_schema</code> <code class="type">sql_identifier</code>
  70       </p>
  71       <p>
  72        Applies to a feature not available in <span class="productname">PostgreSQL</span>
  73       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  74        <code class="structfield">ordering_routine_name</code> <code class="type">sql_identifier</code>
  75       </p>
  76       <p>
  77        Applies to a feature not available in <span class="productname">PostgreSQL</span>
  78       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  79        <code class="structfield">reference_type</code> <code class="type">character_data</code>
  80       </p>
  81       <p>
  82        Applies to a feature not available in <span class="productname">PostgreSQL</span>
  83       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  84        <code class="structfield">data_type</code> <code class="type">character_data</code>
  85       </p>
  86       <p>
  87        Applies to a feature not available in <span class="productname">PostgreSQL</span>
  88       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  89        <code class="structfield">character_maximum_length</code> <code class="type">cardinal_number</code>
  90       </p>
  91       <p>
  92        Applies to a feature not available in <span class="productname">PostgreSQL</span>
  93       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  94        <code class="structfield">character_octet_length</code> <code class="type">cardinal_number</code>
  95       </p>
  96       <p>
  97        Applies to a feature not available in <span class="productname">PostgreSQL</span>
  98       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  99        <code class="structfield">character_set_catalog</code> <code class="type">sql_identifier</code>
 100       </p>
 101       <p>
 102        Applies to a feature not available in <span class="productname">PostgreSQL</span>
 103       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
 104        <code class="structfield">character_set_schema</code> <code class="type">sql_identifier</code>
 105       </p>
 106       <p>
 107        Applies to a feature not available in <span class="productname">PostgreSQL</span>
 108       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
 109        <code class="structfield">character_set_name</code> <code class="type">sql_identifier</code>
 110       </p>
 111       <p>
 112        Applies to a feature not available in <span class="productname">PostgreSQL</span>
 113       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
 114        <code class="structfield">collation_catalog</code> <code class="type">sql_identifier</code>
 115       </p>
 116       <p>
 117        Applies to a feature not available in <span class="productname">PostgreSQL</span>
 118       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
 119        <code class="structfield">collation_schema</code> <code class="type">sql_identifier</code>
 120       </p>
 121       <p>
 122        Applies to a feature not available in <span class="productname">PostgreSQL</span>
 123       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
 124        <code class="structfield">collation_name</code> <code class="type">sql_identifier</code>
 125       </p>
 126       <p>
 127        Applies to a feature not available in <span class="productname">PostgreSQL</span>
 128       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
 129        <code class="structfield">numeric_precision</code> <code class="type">cardinal_number</code>
 130       </p>
 131       <p>
 132        Applies to a feature not available in <span class="productname">PostgreSQL</span>
 133       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
 134        <code class="structfield">numeric_precision_radix</code> <code class="type">cardinal_number</code>
 135       </p>
 136       <p>
 137        Applies to a feature not available in <span class="productname">PostgreSQL</span>
 138       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
 139        <code class="structfield">numeric_scale</code> <code class="type">cardinal_number</code>
 140       </p>
 141       <p>
 142        Applies to a feature not available in <span class="productname">PostgreSQL</span>
 143       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
 144        <code class="structfield">datetime_precision</code> <code class="type">cardinal_number</code>
 145       </p>
 146       <p>
 147        Applies to a feature not available in <span class="productname">PostgreSQL</span>
 148       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
 149        <code class="structfield">interval_type</code> <code class="type">character_data</code>
 150       </p>
 151       <p>
 152        Applies to a feature not available in <span class="productname">PostgreSQL</span>
 153       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
 154        <code class="structfield">interval_precision</code> <code class="type">cardinal_number</code>
 155       </p>
 156       <p>
 157        Applies to a feature not available in <span class="productname">PostgreSQL</span>
 158       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
 159        <code class="structfield">source_dtd_identifier</code> <code class="type">sql_identifier</code>
 160       </p>
 161       <p>
 162        Applies to a feature not available in <span class="productname">PostgreSQL</span>
 163       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
 164        <code class="structfield">ref_dtd_identifier</code> <code class="type">sql_identifier</code>
 165       </p>
 166       <p>
 167        Applies to a feature not available in <span class="productname">PostgreSQL</span>
 168       </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-usage-privileges.html" title="35.59. usage_privileges">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="information-schema.html" title="Chapter 35. The Information Schema">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="infoschema-user-mapping-options.html" title="35.61. user_mapping_options">Next</a></td></tr><tr><td width="40%" align="left" valign="top">35.59. <code class="literal">usage_privileges</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"> 35.61. <code class="literal">user_mapping_options</code></td></tr></table></div></body></html>