Updated on 2026-09-23 GMT+08:00

DBA_OBJECTS

DBA_OBJECTS displays all database objects in the database. Only users with system administrator permissions can access this view.

**Table 1** DBA_OBJECTS columns
Column	Type	Description
owner	Name	Owner of the object
object_name	Name	Object name
object_id	OID	OID of the object
object_type	Name	Type of the object
namespace	OID	Namespace containing the object
created	Timestamp with time zone	Object creation time
last_ddl_time	Timestamp with time zone	Last time when the object was modified

For details about the value ranges of last_ddl_time and last_ddl_time, see PG_OBJECT.

Parent Topic: System Views