USER_OBJECTS
USER_OBJECTS displays all database objects accessible to the current user.
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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.