Baoding-FenShuaJiang
/
Green_GoodERP18_FSJ_Standard
Tarkkaile 1
Äänestä 0
Wiki 捐赠
gooderp18绿色标准版
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Haara: master
Branchit Tagit
${ item.name }
Create branch ${ searchTerm }
from 'master'
${ noResults }
Green_GoodERP18_FSJ_Standard/PostgreSQL/doc/postgresql/html/infoschema-attributes.html

100 lines
12KB
Raaka Pysyvä linkki Blame Historia 

  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>36.6. attributes</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 V1.79.1" /><link rel="prev" href="infoschema-applicable-roles.html" title="36.5. applicable_roles" /><link rel="next" href="infoschema-character-sets.html" title="36.7. character_sets" /></head><body><div xmlns="http://www.w3.org/TR/xhtml1/transitional" class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="5" align="center">36.6. <code xmlns="http://www.w3.org/1999/xhtml" class="literal">attributes</code></th></tr><tr><td width="10%" align="left"><a accesskey="p" href="infoschema-applicable-roles.html" title="36.5. applicable_roles">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="information-schema.html" title="Chapter 36. The Information Schema">Up</a></td><th width="60%" align="center">Chapter 36. The Information Schema</th><td width="10%" align="right"><a accesskey="h" href="index.html" title="PostgreSQL 12.4 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="infoschema-character-sets.html" title="36.7. character_sets">Next</a></td></tr></table><hr></hr></div><div class="sect1" id="INFOSCHEMA-ATTRIBUTES"><div class="titlepage"><div><div><h2 class="title" style="clear: both">36.6. <code class="literal">attributes</code></h2></div></div></div><p>

  3.    The view <code class="literal">attributes</code> contains information about

  4.    the attributes of composite data types defined in the database.

  5.    (Note that the view does not give information about table columns,

  6.    which are sometimes called attributes in PostgreSQL contexts.)

  7.    Only those attributes are shown that the current user has access to (by way

  8.    of being the owner of or having some privilege on the type).

  9.   </p><div class="table" id="id-1.7.6.10.3"><p class="title"><strong>Table 36.4. <code class="literal">attributes</code> Columns</strong></p><div class="table-contents"><table class="table" summary="attributes Columns" border="1"><colgroup><col /><col /><col /></colgroup><thead><tr><th>Name</th><th>Data Type</th><th>Description</th></tr></thead><tbody><tr><td><code class="literal">udt_catalog</code></td><td><code class="type">sql_identifier</code></td><td>Name of the database containing the data type (always the current database)</td></tr><tr><td><code class="literal">udt_schema</code></td><td><code class="type">sql_identifier</code></td><td>Name of the schema containing the data type</td></tr><tr><td><code class="literal">udt_name</code></td><td><code class="type">sql_identifier</code></td><td>Name of the data type</td></tr><tr><td><code class="literal">attribute_name</code></td><td><code class="type">sql_identifier</code></td><td>Name of the attribute</td></tr><tr><td><code class="literal">ordinal_position</code></td><td><code class="type">cardinal_number</code></td><td>Ordinal position of the attribute within the data type (count starts at 1)</td></tr><tr><td><code class="literal">attribute_default</code></td><td><code class="type">character_data</code></td><td>Default expression of the attribute</td></tr><tr><td><code class="literal">is_nullable</code></td><td><code class="type">yes_or_no</code></td><td>

  10.        <code class="literal">YES</code> if the attribute is possibly nullable,

  11.        <code class="literal">NO</code> if it is known not nullable.

  12.       </td></tr><tr><td><code class="literal">data_type</code></td><td><code class="type">character_data</code></td><td>

  13.        Data type of the attribute, if it is a built-in type, or

  14.        <code class="literal">ARRAY</code> if it is some array (in that case, see

  15.        the view <code class="literal">element_types</code>), else

  16.        <code class="literal">USER-DEFINED</code> (in that case, the type is

  17.        identified in <code class="literal">attribute_udt_name</code> and

  18.        associated columns).

  19.       </td></tr><tr><td><code class="literal">character_maximum_length</code></td><td><code class="type">cardinal_number</code></td><td>

  20.        If <code class="literal">data_type</code> identifies a character or bit

  21.        string type, the declared maximum length; null for all other

  22.        data types or if no maximum length was declared.

  23.       </td></tr><tr><td><code class="literal">character_octet_length</code></td><td><code class="type">cardinal_number</code></td><td>

  24.        If <code class="literal">data_type</code> identifies a character type,

  25.        the maximum possible length in octets (bytes) of a datum; null

  26.        for all other data types.  The maximum octet length depends on

  27.        the declared character maximum length (see above) and the

  28.        server encoding.

  29.       </td></tr><tr><td><code class="literal">character_set_catalog</code></td><td><code class="type">sql_identifier</code></td><td>Applies to a feature not available in <span class="productname">PostgreSQL</span></td></tr><tr><td><code class="literal">character_set_schema</code></td><td><code class="type">sql_identifier</code></td><td>Applies to a feature not available in <span class="productname">PostgreSQL</span></td></tr><tr><td><code class="literal">character_set_name</code></td><td><code class="type">sql_identifier</code></td><td>Applies to a feature not available in <span class="productname">PostgreSQL</span></td></tr><tr><td><code class="literal">collation_catalog</code></td><td><code class="type">sql_identifier</code></td><td>

  30.        Name of the database containing the collation of the attribute

  31.        (always the current database), null if default or the data type

  32.        of the attribute is not collatable

  33.       </td></tr><tr><td><code class="literal">collation_schema</code></td><td><code class="type">sql_identifier</code></td><td>

  34.        Name of the schema containing the collation of the attribute,

  35.        null if default or the data type of the attribute is not

  36.        collatable

  37.       </td></tr><tr><td><code class="literal">collation_name</code></td><td><code class="type">sql_identifier</code></td><td>

  38.        Name of the collation of the attribute, null if default or the

  39.        data type of the attribute is not collatable

  40.       </td></tr><tr><td><code class="literal">numeric_precision</code></td><td><code class="type">cardinal_number</code></td><td>

  41.        If <code class="literal">data_type</code> identifies a numeric type, this

  42.        column contains the (declared or implicit) precision of the

  43.        type for this attribute.  The precision indicates the number of

  44.        significant digits.  It can be expressed in decimal (base 10)

  45.        or binary (base 2) terms, as specified in the column

  46.        <code class="literal">numeric_precision_radix</code>.  For all other data

  47.        types, this column is null.

  48.       </td></tr><tr><td><code class="literal">numeric_precision_radix</code></td><td><code class="type">cardinal_number</code></td><td>

  49.        If <code class="literal">data_type</code> identifies a numeric type, this

  50.        column indicates in which base the values in the columns

  51.        <code class="literal">numeric_precision</code> and

  52.        <code class="literal">numeric_scale</code> are expressed.  The value is

  53.        either 2 or 10.  For all other data types, this column is null.

  54.       </td></tr><tr><td><code class="literal">numeric_scale</code></td><td><code class="type">cardinal_number</code></td><td>

  55.        If <code class="literal">data_type</code> identifies an exact numeric

  56.        type, this column contains the (declared or implicit) scale of

  57.        the type for this attribute.  The scale indicates the number of

  58.        significant digits to the right of the decimal point.  It can

  59.        be expressed in decimal (base 10) or binary (base 2) terms, as

  60.        specified in the column

  61.        <code class="literal">numeric_precision_radix</code>.  For all other data

  62.        types, this column is null.

  63.       </td></tr><tr><td><code class="literal">datetime_precision</code></td><td><code class="type">cardinal_number</code></td><td>

  64.        If <code class="literal">data_type</code> identifies a date, time,

  65.        timestamp, or interval type, this column contains the (declared

  66.        or implicit) fractional seconds precision of the type for this

  67.        attribute, that is, the number of decimal digits maintained

  68.        following the decimal point in the seconds value.  For all

  69.        other data types, this column is null.

  70.       </td></tr><tr><td><code class="literal">interval_type</code></td><td><code class="type">character_data</code></td><td>

  71.        If <code class="literal">data_type</code> identifies an interval type,

  72.        this column contains the specification which fields the

  73.        intervals include for this attribute, e.g., <code class="literal">YEAR TO

  74.        MONTH</code>, <code class="literal">DAY TO SECOND</code>, etc.  If no

  75.        field restrictions were specified (that is, the interval

  76.        accepts all fields), and for all other data types, this field

  77.        is null.

  78.       </td></tr><tr><td><code class="literal">interval_precision</code></td><td><code class="type">cardinal_number</code></td><td>

  79.        Applies to a feature not available

  80.        in <span class="productname">PostgreSQL</span>

  81.        (see <code class="literal">datetime_precision</code> for the fractional

  82.        seconds precision of interval type attributes)

  83.       </td></tr><tr><td><code class="literal">attribute_udt_catalog</code></td><td><code class="type">sql_identifier</code></td><td>

  84.        Name of the database that the attribute data type is defined in

  85.        (always the current database)

  86.       </td></tr><tr><td><code class="literal">attribute_udt_schema</code></td><td><code class="type">sql_identifier</code></td><td>

  87.        Name of the schema that the attribute data type is defined in

  88.       </td></tr><tr><td><code class="literal">attribute_udt_name</code></td><td><code class="type">sql_identifier</code></td><td>

  89.        Name of the attribute data type

  90.       </td></tr><tr><td><code class="literal">scope_catalog</code></td><td><code class="type">sql_identifier</code></td><td>Applies to a feature not available in <span class="productname">PostgreSQL</span></td></tr><tr><td><code class="literal">scope_schema</code></td><td><code class="type">sql_identifier</code></td><td>Applies to a feature not available in <span class="productname">PostgreSQL</span></td></tr><tr><td><code class="literal">scope_name</code></td><td><code class="type">sql_identifier</code></td><td>Applies to a feature not available in <span class="productname">PostgreSQL</span></td></tr><tr><td><code class="literal">maximum_cardinality</code></td><td><code class="type">cardinal_number</code></td><td>Always null, because arrays always have unlimited maximum cardinality in <span class="productname">PostgreSQL</span></td></tr><tr><td><code class="literal">dtd_identifier</code></td><td><code class="type">sql_identifier</code></td><td>

  91.        An identifier of the data type descriptor of the column, unique

  92.        among the data type descriptors pertaining to the table.  This

  93.        is mainly useful for joining with other instances of such

  94.        identifiers.  (The specific format of the identifier is not

  95.        defined and not guaranteed to remain the same in future

  96.        versions.)

  97.       </td></tr><tr><td><code class="literal">is_derived_reference_attribute</code></td><td><code class="type">yes_or_no</code></td><td>Applies to a feature not available in <span class="productname">PostgreSQL</span></td></tr></tbody></table></div></div><br class="table-break" /><p>

  98.    See also under <a class="xref" href="infoschema-columns.html" title="36.17. columns">Section 36.17</a>, a similarly

  99.    structured view, for further information on some of the columns.

  100.   </p></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="infoschema-applicable-roles.html">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="information-schema.html">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="infoschema-character-sets.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">36.5. <code class="literal">applicable_roles</code> </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> 36.7. <code class="literal">character_sets</code></td></tr></table></div></body></html>
上海开阖软件有限公司 沪ICP备12045867号-1