Updated on 2023-10-23 GMT+08:00

MY_OBJECTS

MY_OBJECTS displays all 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 (TABLE, INDEX, SEQUENCE, or VIEW)

namespace

oid

Namespace that an object belongs to

created

timestamp with time zone

Creation time of an object

last_ddl_time

timestamp with time zone

Last modification time of an object

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