DB_COLL_TYPES
DB_COLL_TYPES displays information about collection types that can be accessed by the current user. By default, it is accessible to all users. This view exists in both PG_CATALOG and SYS schemas.
Name |
Type |
Description |
---|---|---|
owner |
character varying(128) |
Owner of a cluster. |
type_name |
character varying(128) |
Name of a collection. |
coll_type |
character varying(128) |
Description of a set. |
upper_bound |
numeric |
Not supported. Its value is NULL. |
elem_type_mod |
character varying(7) |
Not supported. Its value is NULL. |
elem_type_name |
character varying(128) |
Name of the data type or user-defined type on which the collection is based. |
length |
numeric |
Not supported. Its value is NULL. |
precision |
numeric |
Not supported. Its value is NULL. |
scale |
numeric |
Not supported. Its value is NULL. |
character_set_name |
character varying(44) |
Not supported. Its value is NULL. |
elem_storage |
character varying(7) |
Not supported. Its value is NULL. |
nulls_stored |
character varying(3) |
Not supported. Its value is NULL. |
char_used |
character varying(1) |
Not supported. Its value is NULL. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.