| Column Type

Description

| | --- | |

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), USER-DEFINED TYPE (the array is used by an attribute of that composite type), DOMAIN (the array is used by that domain), ROUTINE (the array is used by a parameter or the return data type of that function).

| |

collection_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

Name of the database containing the collation of the element type (always the current database), null if default or the data type of the element is not collatable

| |

collation_schema sql_identifier

Name of the schema containing the collation of the element type, null if default or the data type of the element is not collatable

| |

collation_name sql_identifier

Name of the collation of the element type, null if default or the data type of the element is not collatable

| |

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 cardinal_number

Always null, since this information is not applied to array element data types in PostgreSQL

| |

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.

|