DB_OBJECTS
DB_OBJECTS displays all database objects accessible to the current user. This view exists in both PG_CATALOG and SYS schemas.
Name |
Type |
Description |
---|---|---|
owner |
name |
Object owner. |
object_name |
name |
Object name. |
object_id |
oid |
Object OID. |
object_type |
name |
Object type. |
namespace |
oid |
ID of the namespace where the object resides. |
temporary |
character(1) |
Specifies whether the object is a temporary object. |
status |
character varying(7) |
Object status. |
subobject_name |
name |
Subobject name of the object. |
generated |
character(1) |
Specifies whether the object name is generated by the system. |
created |
timestamp with time zone |
Time when the object was created. |
last_ddl_time |
timestamp with time zone |
Last time when the 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. |

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