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 |
OID of the object. |
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 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 the object. |
last_ddl_time |
timestamp with time zone |
Last modification time of the object. |
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 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