GaussDB-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. |
NOTICE:
For details on the value ranges of created and last_ddl_time, see PG_OBJECT.
更多详情请参考GaussDB 文档中心：doc.hcs.huawei.com/db/zh-cn/ga…
