diff options
Diffstat (limited to 'doc/src/sgml/html/infoschema-element-types.html')
-rw-r--r-- | doc/src/sgml/html/infoschema-element-types.html | 194 |
1 files changed, 194 insertions, 0 deletions
diff --git a/doc/src/sgml/html/infoschema-element-types.html b/doc/src/sgml/html/infoschema-element-types.html new file mode 100644 index 0000000..c513cc3 --- /dev/null +++ b/doc/src/sgml/html/infoschema-element-types.html @@ -0,0 +1,194 @@ +<?xml version="1.0" encoding="UTF-8" standalone="no"?> +<!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.24. element_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-domains.html" title="37.23. domains" /><link rel="next" href="infoschema-enabled-roles.html" title="37.25. enabled_roles" /></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.24. <code class="literal">element_types</code></th></tr><tr><td width="10%" align="left"><a accesskey="p" href="infoschema-domains.html" title="37.23. domains">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 15.5 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="infoschema-enabled-roles.html" title="37.25. enabled_roles">Next</a></td></tr></table><hr /></div><div class="sect1" id="INFOSCHEMA-ELEMENT-TYPES"><div class="titlepage"><div><div><h2 class="title" style="clear: both">37.24. <code class="literal">element_types</code></h2></div></div></div><p> + The view <code class="literal">element_types</code> contains the data type + descriptors of the elements of arrays. When a table column, composite-type attribute, + domain, function parameter, or function return value is defined to + be of an array type, the respective information schema view only + contains <code class="literal">ARRAY</code> in the column + <code class="literal">data_type</code>. To obtain information on the element + type of the array, you can join the respective view with this view. + For example, to show the columns of a table with data types and + array element types, if applicable, you could do: +</p><pre class="programlisting"> +SELECT c.column_name, c.data_type, e.data_type AS element_type +FROM information_schema.columns c LEFT JOIN information_schema.element_types e + ON ((c.table_catalog, c.table_schema, c.table_name, 'TABLE', c.dtd_identifier) + = (e.object_catalog, e.object_schema, e.object_name, e.object_type, e.collection_type_identifier)) +WHERE c.table_schema = '...' AND c.table_name = '...' +ORDER BY c.ordinal_position; +</pre><p> + This view only includes objects that the current user has access + to, by way of being the owner or having some privilege. + </p><div class="table" id="id-1.7.6.28.3"><p class="title"><strong>Table 37.22. <code class="structname">element_types</code> Columns</strong></p><div class="table-contents"><table class="table" summary="element_types Columns" border="1"><colgroup><col /></colgroup><thead><tr><th class="catalog_table_entry"><p class="column_definition"> + Column Type + </p> + <p> + Description + </p></th></tr></thead><tbody><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">object_catalog</code> <code class="type">sql_identifier</code> + </p> + <p> + Name of the database that contains the object that uses the + array being described (always the current database) + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">object_schema</code> <code class="type">sql_identifier</code> + </p> + <p> + Name of the schema that contains the object that uses the array + being described + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">object_name</code> <code class="type">sql_identifier</code> + </p> + <p> + Name of the object that uses the array being described + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">object_type</code> <code class="type">character_data</code> + </p> + <p> + The type of the object that uses the array being described: one + of <code class="literal">TABLE</code> (the array is used by a column of + that table), <code class="literal">USER-DEFINED TYPE</code> (the array is + used by an attribute of that composite type), + <code class="literal">DOMAIN</code> (the array is used by that domain), + <code class="literal">ROUTINE</code> (the array is used by a parameter or + the return data type of that function). + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">collection_type_identifier</code> <code class="type">sql_identifier</code> + </p> + <p> + The identifier of the data type descriptor of the array being + described. Use this to join with the + <code class="literal">dtd_identifier</code> columns of other information + schema views. + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">data_type</code> <code class="type">character_data</code> + </p> + <p> + Data type of the array elements, if it is a built-in type, else + <code class="literal">USER-DEFINED</code> (in that case, the type is + identified in <code class="literal">udt_name</code> and associated + columns). + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">character_maximum_length</code> <code class="type">cardinal_number</code> + </p> + <p> + Always null, since this information is not applied to array element data types in <span class="productname">PostgreSQL</span> + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">character_octet_length</code> <code class="type">cardinal_number</code> + </p> + <p> + Always null, since this information is not applied to array element data types in <span class="productname">PostgreSQL</span> + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">character_set_catalog</code> <code class="type">sql_identifier</code> + </p> + <p> + Applies to a feature not available in <span class="productname">PostgreSQL</span> + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">character_set_schema</code> <code class="type">sql_identifier</code> + </p> + <p> + Applies to a feature not available in <span class="productname">PostgreSQL</span> + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">character_set_name</code> <code class="type">sql_identifier</code> + </p> + <p> + Applies to a feature not available in <span class="productname">PostgreSQL</span> + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">collation_catalog</code> <code class="type">sql_identifier</code> + </p> + <p> + Name of the database containing the collation of the element + type (always the current database), null if default or the data + type of the element is not collatable + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">collation_schema</code> <code class="type">sql_identifier</code> + </p> + <p> + Name of the schema containing the collation of the element + type, null if default or the data type of the element is not + collatable + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">collation_name</code> <code class="type">sql_identifier</code> + </p> + <p> + Name of the collation of the element type, null if default or + the data type of the element is not collatable + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">numeric_precision</code> <code class="type">cardinal_number</code> + </p> + <p> + Always null, since this information is not applied to array element data types in <span class="productname">PostgreSQL</span> + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">numeric_precision_radix</code> <code class="type">cardinal_number</code> + </p> + <p> + Always null, since this information is not applied to array element data types in <span class="productname">PostgreSQL</span> + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">numeric_scale</code> <code class="type">cardinal_number</code> + </p> + <p> + Always null, since this information is not applied to array element data types in <span class="productname">PostgreSQL</span> + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">datetime_precision</code> <code class="type">cardinal_number</code> + </p> + <p> + Always null, since this information is not applied to array element data types in <span class="productname">PostgreSQL</span> + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">interval_type</code> <code class="type">character_data</code> + </p> + <p> + Always null, since this information is not applied to array element data types in <span class="productname">PostgreSQL</span> + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">interval_precision</code> <code class="type">cardinal_number</code> + </p> + <p> + Always null, since this information is not applied to array element data types in <span class="productname">PostgreSQL</span> + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">domain_default</code> <code class="type">character_data</code> + </p> + <p> + Not yet implemented + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">udt_catalog</code> <code class="type">sql_identifier</code> + </p> + <p> + Name of the database that the data type of the elements is + defined in (always the current database) + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">udt_schema</code> <code class="type">sql_identifier</code> + </p> + <p> + Name of the schema that the data type of the elements is + defined in + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">udt_name</code> <code class="type">sql_identifier</code> + </p> + <p> + Name of the data type of the elements + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">scope_catalog</code> <code class="type">sql_identifier</code> + </p> + <p> + Applies to a feature not available in <span class="productname">PostgreSQL</span> + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">scope_schema</code> <code class="type">sql_identifier</code> + </p> + <p> + Applies to a feature not available in <span class="productname">PostgreSQL</span> + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">scope_name</code> <code class="type">sql_identifier</code> + </p> + <p> + Applies to a feature not available in <span class="productname">PostgreSQL</span> + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">maximum_cardinality</code> <code class="type">cardinal_number</code> + </p> + <p> + Always null, because arrays always have unlimited maximum cardinality in <span class="productname">PostgreSQL</span> + </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition"> + <code class="structfield">dtd_identifier</code> <code class="type">sql_identifier</code> + </p> + <p> + An identifier of the data type descriptor of the element. This + is currently not useful. + </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-domains.html" title="37.23. domains">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-enabled-roles.html" title="37.25. enabled_roles">Next</a></td></tr><tr><td width="40%" align="left" valign="top">37.23. <code class="literal">domains</code> </td><td width="20%" align="center"><a accesskey="h" href="index.html" title="PostgreSQL 15.5 Documentation">Home</a></td><td width="40%" align="right" valign="top"> 37.25. <code class="literal">enabled_roles</code></td></tr></table></div></body></html>
\ No newline at end of file |