ALL_OBJECTS¶
ALL_OBJECTS displays all database objects accessible to the current user.
Name | 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 | ID of the namespace where the object resides |
created | timestamp with time zone | Object creation time |
last_ddl_time | timestamp with time zone | The last time when an object was modified. |
Important
For details about the value ranges of last_ddl_time and last_ddl_time, see PG_OBJECT.