Movatterモバイル変換

The viewelement_types contains the data type descriptors of the elements of arrays. When a table column, composite-type attribute, domain, function parameter, or function return value is defined to be of an array type, the respective information schema view only containsARRAY in the columndata_type. To obtain information on the element type of the array, you can join the respective view with this view. For example, to show the columns of a table with data types and array element types, if applicable, you could do:

SELECT c.column_name, c.data_type, e.data_type AS element_typeFROM information_schema.columns c LEFT JOIN information_schema.element_types e     ON ((c.table_catalog, c.table_schema, c.table_name, 'TABLE', c.dtd_identifier)       = (e.object_catalog, e.object_schema, e.object_name, e.object_type, e.collection_type_identifier))WHERE c.table_schema = '...' AND c.table_name = '...'ORDER BY c.ordinal_position;

This view only includes objects that the current user has access to, by way of being the owner or having some privilege.