element_types

The element_types view provides information about element types used by arrays.

Column name	Data type	Description
object_catalog	sql_identifier	The name of the current database that contains the object using the array being described.
object_schema	sql_identifier	The name of the schema that contains the object using the array being described.
object_name	sql_identifier	The name of the object that uses the array being described.
object_type	character_data	The type of the object that uses the array. The possible values are: TABLE – An array used by a column. USER-DEFINED TYPE – An array used by a composite type attribute. DOMAIN – An array used by a domain. ROUTINE – An array used by a parameter or return type.
collection_type_identifier	sql_identifier	The identifier of the data type descriptor of the array being described; used to join with dtd_identifier columns of other information schema views.
data_type	character_data	The data type of the array elements. For built-in types, it is a type name; for USER-DEFINED, the element type is identified by udt_name and related columns.
character_maximum_length	cardinal_number	The character maximum length applied to array element data types. Always NULL.
character_octet_length	cardinal_number	The octet length limits applied to array element data types. Always NULL, not applicable in PostgreSQL.
character_set_catalog	sql_identifier	Applies to a feature that is not available in PostgreSQL.
character_set_schema	sql_identifier	Applies to a feature that is not available in PostgreSQL.
character_set_name	sql_identifier	Applies to a feature that is not available in PostgreSQL.
collation_catalog	sql_identifier	The name of the current database containing the collation of the element type. NULL – Default or non-collatable.
collation_schema	sql_identifier	The name of the schema containing the collation of the element type. NULL – Default or non-collatable.
collation_name	sql_identifier	The name of the collation of the element type. NULL – Default or non-collatable.
numeric_precision	cardinal_number	The numeric precision of array element data types. Always NULL, not applicable in PostgreSQL.
numeric_precision_radix	cardinal_number	A numeric precision radix of array element data types. Always NULL, not applicable in PostgreSQL.
numeric_scale	cardinal_number	The numeric scale of array element data types. Always NULL, not applicable in PostgreSQL.
datetime_precision	cardinal_number	The datetime precision of array element data types. Always NULL, not applicable in PostgreSQL.
interval_type	character_data	Interval type constraints of array element data types. Always NULL, not applicable in PostgreSQL.
interval_precision	cardinal_number	The interval precision of array element data types. Always NULL, not applicable in PostgreSQL.
udt_catalog	sql_identifier	The name of the current database in which the element data type is defined.
udt_schema	sql_identifier	The name of the schema in which the element data type is defined.
udt_name	sql_identifier	The name of the element data type.
scope_catalog	sql_identifier	Applies to a feature that is not available in PostgreSQL.
scope_schema	sql_identifier	Applies to a feature that is not available in PostgreSQL.
scope_name	sql_identifier	Applies to a feature that is not available in PostgreSQL.
maximum_cardinality	cardinal_number	The maximum cardinality of the array. Always NULL, because arrays in PostgreSQL have unlimited maximum cardinality.
dtd_identifier	sql_identifier	The identifier of the data type descriptor of the element, currently not in use.