Updated on 2024-06-03 GMT+08:00

MY_OBJECTS

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

Table 1 MY_OBJECTS columns

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, VIEW, or GLOBAL SECONDARY INDEX).

namespace

oid

Namespace that an object belongs to.

temporary

character(1)

Specifies whether an object is a temporary object.

status

character varying(7)

Object status.

subobject_name

name

Subobject name of an object.

generated

character(1)

Specifies whether an object name is generated by the system.

created

timestamp with time zone

Creation time of an object.

last_ddl_time

timestamp with time zone

Last time when an object was modified.

default_collation

character varying(100)

Default collation of objects.

data_object_id

numeric

Not supported. Set it to NULL.

timestamp

character varying(19)

Not supported. Set it to NULL.

secondary

character varying(1)

Not supported. Set it to NULL.

edition_name

character varying(128)

Not supported. Set it to NULL.

sharing

character varying(18)

Not supported. Set it to NULL.

editionable

character varying(1)

Not supported. Set it to NULL.

oracle_maintained

character varying(1)

Not supported. Set it to NULL.

application

character varying(1)

Not supported. Set it to NULL.

duplicated

character varying(1)

Not supported. Set it to NULL.

sharded

character varying(1)

Not supported. Set it to NULL.

created_appid

numeric

Not supported. Set it to NULL.

modified_appid

numeric

Not supported. Set it to NULL.

created_vsnid

numeric

Not supported. Set it to NULL.

modified_vsnid

numeric

Not supported. Set it to NULL.

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