object_catalog
|
sql_identifier
|
Name of the database that contains the object that uses the array being described (always the current database) |
object_schema
|
sql_identifier
|
Name of the schema that contains the object that uses the array being described |
object_name
|
sql_identifier
|
Name of the object that uses the array being described |
object_type
|
character_data
|
The type of the object that uses the array being described: one of TABLE (the array is used by a column of that table), DOMAIN (the array is used by that domain), ROUTINE (the array is used by a parameter or the return data type of that function). |
array_type_identifier
|
sql_identifier
|
The identifier of the data type descriptor of the array being described. Use this to join with the dtd_identifier columns of other information schema views. |
data_type
|
character_data
|
Data type of the array elements, if it is a built-in type, else USER-DEFINED (in that case, the type is identified in udt_name and associated columns). |
character_maximum_length
|
cardinal_number
|
Always null, since this information is not applied to array element data types in PostgreSQL
|
character_octet_length
|
cardinal_number
|
Always null, since this information is not applied to array element data types in PostgreSQL
|
character_set_catalog
|
sql_identifier
|
Applies to a feature not available in PostgreSQL
|
character_set_schema
|
sql_identifier
|
Applies to a feature not available in PostgreSQL
|
character_set_name
|
sql_identifier
|
Applies to a feature not available in PostgreSQL
|
collation_catalog
|
sql_identifier
|
Applies to a feature not available in PostgreSQL
|
collation_schema
|
sql_identifier
|
Applies to a feature not available in PostgreSQL
|
collation_name
|
sql_identifier
|
Applies to a feature not available in PostgreSQL
|
numeric_precision
|
cardinal_number
|
Always null, since this information is not applied to array element data types in PostgreSQL
|
numeric_precision_radix
|
cardinal_number
|
Always null, since this information is not applied to array element data types in PostgreSQL
|
numeric_scale
|
cardinal_number
|
Always null, since this information is not applied to array element data types in PostgreSQL
|
datetime_precision
|
cardinal_number
|
Always null, since this information is not applied to array element data types in PostgreSQL
|
interval_type
|
character_data
|
Always null, since this information is not applied to array element data types in PostgreSQL
|
interval_precision
|
character_data
|
Always null, since this information is not applied to array element data types in PostgreSQL
|
domain_default
|
character_data
|
Not yet implemented |
udt_catalog
|
sql_identifier
|
Name of the database that the data type of the elements is defined in (always the current database) |
udt_schema
|
sql_identifier
|
Name of the schema that the data type of the elements is defined in |
udt_name
|
sql_identifier
|
Name of the data type of the elements |
scope_catalog
|
sql_identifier
|
Applies to a feature not available in PostgreSQL
|
scope_schema
|
sql_identifier
|
Applies to a feature not available in PostgreSQL
|
scope_name
|
sql_identifier
|
Applies to a feature not available in PostgreSQL
|
maximum_cardinality
|
cardinal_number
|
Always null, because arrays always have unlimited maximum cardinality in PostgreSQL
|
dtd_identifier
|
sql_identifier
|
An identifier of the data type descriptor of the element. This is currently not useful. |