codekingpro/portable-devtools
114k
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.23. domains</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-domain-udt-usage.html" title="37.22. domain_udt_usage" /><link rel="next" href="infoschema-element-types.html" title="37.24. element_types" /></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.23. <code class="literal">domains</code></th></tr><tr><td width="10%" align="left"><a accesskey="p" href="infoschema-domain-udt-usage.html" title="37.22. domain_udt_usage">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-element-types.html" title="37.24. element_types">Next</a></td></tr></table><hr /></div><div class="sect1" id="INFOSCHEMA-DOMAINS"><div class="titlepage"><div><div><h2 class="title" style="clear: both">37.23. <code class="literal">domains</code> <a href="#INFOSCHEMA-DOMAINS" class="id_link">#</a></h2></div></div></div><p>3 The view <code class="literal">domains</code> contains all4 <a class="glossterm" href="glossary.html#GLOSSARY-DOMAIN"><em class="glossterm"><a class="glossterm" href="glossary.html#GLOSSARY-DOMAIN" title="Domain">domains</a></em></a> defined in the5 current database. Only those domains are shown that the current user has6 access to (by way of being the owner or having some privilege).7 </p><div class="table" id="id-1.7.6.27.3"><p class="title"><strong>Table 37.21. <code class="structname">domains</code> Columns</strong></p><div class="table-contents"><table class="table" summary="domains Columns" border="1"><colgroup><col /></colgroup><thead><tr><th class="catalog_table_entry"><p class="column_definition">8 Column Type9 </p>10 <p>11 Description12 </p></th></tr></thead><tbody><tr><td class="catalog_table_entry"><p class="column_definition">13 <code class="structfield">domain_catalog</code> <code class="type">sql_identifier</code>14 </p>15 <p>16 Name of the database that contains the domain (always the current database)17 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">18 <code class="structfield">domain_schema</code> <code class="type">sql_identifier</code>19 </p>20 <p>21 Name of the schema that contains the domain22 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">23 <code class="structfield">domain_name</code> <code class="type">sql_identifier</code>24 </p>25 <p>26 Name of the domain27 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">28 <code class="structfield">data_type</code> <code class="type">character_data</code>29 </p>30 <p>31 Data type of the domain, if it is a built-in type, or32 <code class="literal">ARRAY</code> if it is some array (in that case, see33 the view <code class="literal">element_types</code>), else34 <code class="literal">USER-DEFINED</code> (in that case, the type is35 identified in <code class="literal">udt_name</code> and associated36 columns).37 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">38 <code class="structfield">character_maximum_length</code> <code class="type">cardinal_number</code>39 </p>40 <p>41 If the domain has a character or bit string type, the declared42 maximum length; null for all other data types or if no maximum43 length was declared.44 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">45 <code class="structfield">character_octet_length</code> <code class="type">cardinal_number</code>46 </p>47 <p>48 If the domain has a character type, the maximum possible length49 in octets (bytes) of a datum; null for all other data types.50 The maximum octet length depends on the declared character51 maximum length (see above) and the server encoding.52 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">53 <code class="structfield">character_set_catalog</code> <code class="type">sql_identifier</code>54 </p>55 <p>56 Applies to a feature not available in <span class="productname">PostgreSQL</span>57 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">58 <code class="structfield">character_set_schema</code> <code class="type">sql_identifier</code>59 </p>60 <p>61 Applies to a feature not available in <span class="productname">PostgreSQL</span>62 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">63 <code class="structfield">character_set_name</code> <code class="type">sql_identifier</code>64 </p>65 <p>66 Applies to a feature not available in <span class="productname">PostgreSQL</span>67 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">68 <code class="structfield">collation_catalog</code> <code class="type">sql_identifier</code>69 </p>70 <p>71 Name of the database containing the collation of the domain72 (always the current database), null if default or the data type73 of the domain is not collatable74 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">75 <code class="structfield">collation_schema</code> <code class="type">sql_identifier</code>76 </p>77 <p>78 Name of the schema containing the collation of the domain, null79 if default or the data type of the domain is not collatable80 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">81 <code class="structfield">collation_name</code> <code class="type">sql_identifier</code>82 </p>83 <p>84 Name of the collation of the domain, null if default or the85 data type of the domain is not collatable86 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">87 <code class="structfield">numeric_precision</code> <code class="type">cardinal_number</code>88 </p>89 <p>90 If the domain has a numeric type, this column contains the91 (declared or implicit) precision of the type for this domain.92 The precision indicates the number of significant digits. It93 can be expressed in decimal (base 10) or binary (base 2) terms,94 as specified in the column95 <code class="literal">numeric_precision_radix</code>. For all other data96 types, this column is null.97 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">98 <code class="structfield">numeric_precision_radix</code> <code class="type">cardinal_number</code>99 </p>100 <p>101 If the domain has a numeric type, this column indicates in102 which base the values in the columns103 <code class="literal">numeric_precision</code> and104 <code class="literal">numeric_scale</code> are expressed. The value is105 either 2 or 10. For all other data types, this column is null.106 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">107 <code class="structfield">numeric_scale</code> <code class="type">cardinal_number</code>108 </p>109 <p>110 If the domain has an exact numeric type, this column contains111 the (declared or implicit) scale of the type for this domain.112 The scale indicates the number of significant digits to the113 right of the decimal point. It can be expressed in decimal114 (base 10) or binary (base 2) terms, as specified in the column115 <code class="literal">numeric_precision_radix</code>. For all other data116 types, this column is null.117 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">118 <code class="structfield">datetime_precision</code> <code class="type">cardinal_number</code>119 </p>120 <p>121 If <code class="literal">data_type</code> identifies a date, time,122 timestamp, or interval type, this column contains the (declared123 or implicit) fractional seconds precision of the type for this124 domain, that is, the number of decimal digits maintained125 following the decimal point in the seconds value. For all126 other data types, this column is null.127 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">128 <code class="structfield">interval_type</code> <code class="type">character_data</code>129 </p>130 <p>131 If <code class="literal">data_type</code> identifies an interval type,132 this column contains the specification which fields the133 intervals include for this domain, e.g., <code class="literal">YEAR TO134 MONTH</code>, <code class="literal">DAY TO SECOND</code>, etc. If no135 field restrictions were specified (that is, the interval136 accepts all fields), and for all other data types, this field137 is null.138 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">139 <code class="structfield">interval_precision</code> <code class="type">cardinal_number</code>140 </p>141 <p>142 Applies to a feature not available143 in <span class="productname">PostgreSQL</span>144 (see <code class="literal">datetime_precision</code> for the fractional145 seconds precision of interval type domains)146 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">147 <code class="structfield">domain_default</code> <code class="type">character_data</code>148 </p>149 <p>150 Default expression of the domain151 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">152 <code class="structfield">udt_catalog</code> <code class="type">sql_identifier</code>153 </p>154 <p>155 Name of the database that the domain data type is defined in (always the current database)156 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">157 <code class="structfield">udt_schema</code> <code class="type">sql_identifier</code>158 </p>159 <p>160 Name of the schema that the domain data type is defined in161 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">162 <code class="structfield">udt_name</code> <code class="type">sql_identifier</code>163 </p>164 <p>165 Name of the domain data type166 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">167 <code class="structfield">scope_catalog</code> <code class="type">sql_identifier</code>168 </p>169 <p>170 Applies to a feature not available in <span class="productname">PostgreSQL</span>171 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">172 <code class="structfield">scope_schema</code> <code class="type">sql_identifier</code>173 </p>174 <p>175 Applies to a feature not available in <span class="productname">PostgreSQL</span>176 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">177 <code class="structfield">scope_name</code> <code class="type">sql_identifier</code>178 </p>179 <p>180 Applies to a feature not available in <span class="productname">PostgreSQL</span>181 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">182 <code class="structfield">maximum_cardinality</code> <code class="type">cardinal_number</code>183 </p>184 <p>185 Always null, because arrays always have unlimited maximum cardinality in <span class="productname">PostgreSQL</span>186 </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">187 <code class="structfield">dtd_identifier</code> <code class="type">sql_identifier</code>188 </p>189 <p>190 An identifier of the data type descriptor of the domain, unique191 among the data type descriptors pertaining to the domain (which192 is trivial, because a domain only contains one data type193 descriptor). This is mainly useful for joining with other194 instances of such identifiers. (The specific format of the195 identifier is not defined and not guaranteed to remain the same196 in future versions.)197 </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-domain-udt-usage.html" title="37.22. domain_udt_usage">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-element-types.html" title="37.24. element_types">Next</a></td></tr><tr><td width="40%" align="left" valign="top">37.22. <code class="literal">domain_udt_usage</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.24. <code class="literal">element_types</code></td></tr></table></div></body></html>