Updated on 2025-07-15 GMT+08:00

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.