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 |
Object OID. |
object_type |
name |
Object class. |
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. |
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. 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. |

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.