MY_OBJECTS

MY_OBJECTS displays database objects accessible to the current user. This view exists in both PG_CATALOG and SYS schema.

**Table 1** MY_OBJECTS columns
Name	Type	Description
object_name	name	Object name.
object_id	oid	Object OID.
object_type	name	Object type, including TABLE, INDEX, SEQUENCE, and VIEW.
namespace	oid	Namespace that the object belongs to.
created	timestamp with time zone	Creation time of the object.
last_ddl_time	timestamp with time zone	Last modification time of the object.

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

Parent topic: System Views

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.