DBA_OBJECTS¶
DBA_OBJECTS displays all database objects in the database. This view is accessible only to users with system administrator rights.
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 |
Important
For details about the value ranges of last_ddl_time and last_ddl_time, see PG_OBJECT.