attributes
#
The view attributes
contains information about
the attributes of composite data types defined in the database.
(Note that the view does not give information about table columns,
which are sometimes called attributes in PostgreSQL contexts.)
Only those attributes are shown that the current user has access to (by way
of being the owner of or having some privilege on the type).
Table 37.4. attributes
Columns
Column Type Description |
---|
Name of the database containing the data type (always the current database) |
Name of the schema containing the data type |
Name of the data type |
Name of the attribute |
Ordinal position of the attribute within the data type (count starts at 1) |
Default expression of the attribute |
|
Data type of the attribute, if it is a built-in type, or
|
If |
If |
Applies to a feature not available in PostgreSQL |
Applies to a feature not available in PostgreSQL |
Applies to a feature not available in PostgreSQL |
Name of the database containing the collation of the attribute (always the current database), null if default or the data type of the attribute is not collatable |
Name of the schema containing the collation of the attribute, null if default or the data type of the attribute is not collatable |
Name of the collation of the attribute, null if default or the data type of the attribute is not collatable |
If |
If |
If |
If |
If |
Applies to a feature not available
in PostgreSQL
(see |
Name of the database that the attribute data type is defined in (always the current database) |
Name of the schema that the attribute data type is defined in |
Name of the attribute data type |
Applies to a feature not available in PostgreSQL |
Applies to a feature not available in PostgreSQL |
Applies to a feature not available in PostgreSQL |
Always null, because arrays always have unlimited maximum cardinality in PostgreSQL |
An identifier of the data type descriptor of the attribute, unique among the data type descriptors pertaining to the composite type. This is mainly useful for joining with other instances of such identifiers. (The specific format of the identifier is not defined and not guaranteed to remain the same in future versions.) |
Applies to a feature not available in PostgreSQL |
See also under Section 37.17, a similarly structured view, for further information on some of the columns.