USER_OBJECTS¶
USER_OBJECTS displays all database objects accessible to the current user.
Name | Type | Description |
---|---|---|
object_name | name | Object name |
object_id | oid | OID of the object |
object_type | name | Type of the object (TABLE, INDEX, SEQUENCE, or VIEW) |
namespace | oid | Namespace that the object belongs to |
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.