MY_COLL_TYPES
MY_COLL_TYPES displays information about types of collections created by the current user. By default, it is accessible to all users. This view exists in both PG_CATALOG and SYS schema.
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.
