DB_OBJECTS
DB_OBJECTS displays all database objects accessible to the current user. This view exists in both PG_CATALOG and SYS schema.
Name |
Type |
Description |
---|---|---|
owner |
name |
Object owner. |
object_name |
name |
Object name. |
object_id |
oid |
OID of the object. |
object_type |
name |
Object class. |
namespace |
oid |
ID of the namespace where the object resides. |
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 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 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