MY_OBJECTS
MY_OBJECTS displays database objects accessible to the current user. This view exists in both PG_CATALOG and SYS schema.
| Name | Type | Description |
|---|---|---|
| object_name | name | Object name. |
| object_id | oid | Object OID. |
| object_type | name | Type of the object (TABLE, INDEX, SEQUENCE, VIEW, or GLOBAL SECONDARY INDEX). |
| namespace | oid | Namespace that the object belongs to. |
| temporary | character(1) | Specifies whether the object is a temporary object. |
| status | character varying(7) | Object status. |
| subobject_name | name | Subobject name of an object. |
| generated | character(1) | Specifies whether the object name is generated by the system. |
| created | timestamp with time zone | Time when the object was created. |
| last_ddl_time | timestamp with time zone | Last time when the object was modified. |
| default_collation | character varying(100) | Default collation of objects. |
| data_object_id | numeric | Not supported. Its value is NULL. |
| timestamp | character varying(19) | Not supported. Its value is NULL. |
| secondary | character varying(1) | Not supported. Its value is NULL. |
| edition_name | character varying(128) | Not supported. Its value is NULL. |
| sharing | character varying(18) | Not supported. Its value is NULL. |
| editionable | character varying(1) | Not supported. Its value is NULL. |
| oracle_maintained | character varying(1) | Not supported. Its value is NULL. |
| application | character varying(1) | Not supported. Its value is NULL. |
| duplicated | character varying(1) | Not supported. Its value is NULL. |
| sharded | character varying(1) | Not supported. Its value is NULL. |
| created_appid | numeric | Not supported. Its value is NULL. |
| modified_appid | numeric | Not supported. Its value is NULL. |
| created_vsnid | numeric | Not supported. Its value is NULL. |
| modified_vsnid | numeric | Not supported. Its value is NULL. |
For details about the value ranges of created and last_ddl_time, see PG_OBJECT.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
