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 |
Object OID. |
object_type |
name |
Object type (TABLE, INDEX, SEQUENCE, or VIEW). |
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 modification time of an object. |
default_collation |
character varying(100) |
Default collation of objects. |
data_object_id |
numeric |
Not supported. The value is NULL. |
timestamp |
character varying(19) |
Not supported. The value is NULL. |
secondary |
character varying(1) |
Not supported. The value is NULL. |
edition_name |
character varying(128) |
Not supported. The value is NULL. |
sharing |
character varying(18) |
Not supported. The value is NULL. |
editionable |
character varying(1) |
Not supported. The value is NULL. |
oracle_maintained |
character varying(1) |
Not supported. The value is NULL. |
application |
character varying(1) |
Not supported. The value is NULL. |
duplicated |
character varying(1) |
Not supported. The value is NULL. |
sharded |
character varying(1) |
Not supported. The value is NULL. |
created_appid |
numeric |
Not supported. The value is NULL. |
modified_appid |
numeric |
Not supported. The value is NULL. |
created_vsnid |
numeric |
Not supported. The value is NULL. |
modified_vsnid |
numeric |
Not supported. The 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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot