MY_OBJECTS
MY_OBJECTS displays database objects accessible to the current user. This view exists in the PG_CATALOG and SYS schemas.
Name |
Type |
Description |
---|---|---|
object_name |
name |
Object name. |
object_id |
oid |
OID of the object. |
object_type |
name |
Type of the object (TABLE, INDEX, SEQUENCE, VIEW, or GLOBAL SECONDARY INDEX). |
namespace |
oid |
Namespace that an object belongs to. |
temporary |
character(1) |
Specifies whether an object is a temporary object. |
status |
character varying(7) |
Object status. |
subobject_name |
name |
Subobject name of an object. |
generated |
character(1) |
Specifies whether an object name is generated by the system. |
created |
timestamp with time zone |
Creation time of an object. |
last_ddl_time |
timestamp with time zone |
Last time when an object was modified. |
default_collation |
character varying(100) |
Default collation of objects. |
data_object_id |
numeric |
Not supported. Set it to NULL. |
timestamp |
character varying(19) |
Not supported. Set it to NULL. |
secondary |
character varying(1) |
Not supported. Set it to NULL. |
edition_name |
character varying(128) |
Not supported. Set it to NULL. |
sharing |
character varying(18) |
Not supported. Set it to NULL. |
editionable |
character varying(1) |
Not supported. Set it to NULL. |
oracle_maintained |
character varying(1) |
Not supported. Set it to NULL. |
application |
character varying(1) |
Not supported. Set it to NULL. |
duplicated |
character varying(1) |
Not supported. Set it to NULL. |
sharded |
character varying(1) |
Not supported. Set it to NULL. |
created_appid |
numeric |
Not supported. Set it to NULL. |
modified_appid |
numeric |
Not supported. Set it to NULL. |
created_vsnid |
numeric |
Not supported. Set it to NULL. |
modified_vsnid |
numeric |
Not supported. Set it to NULL. |
For details on 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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot