GaussDB-DB_OBJECTS
DB_OBJECTS displays all database objects accessible to the current user. This view exists in the PG_CATALOG and SYS schemas.
| Name | Type | Description |
|---|---|---|
| owner | name | Object owner. |
| object_name | name | Object name. |
| object_id | oid | OID of the object. |
| object_type | name | Object type. |
| namespace | oid | ID of the namespace where an object resides. |
| temporary | character(1) | Specifies whether an object is a temporary object. |
| status | character varying(7) | Object status.- valid: The object is valid. |
- invalid: The object is invalid. | | 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. 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. |
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…