MY_TYPES

MY_TYPES describes all object types owned by the current user. All users can access this view. This view exists in the PG_CATALOG and SYS schemas.

**Table 1** MY_TYPES columns
Name	Type	Description
type_name	character varying(128)	Type name.
type_oid	raw	Type OID
typecode	character varying(128)	Type code.
attributes	numeric	Number of attributes in a type.
methods	numeric	Not supported. Set it to 0.
predefined	character varying(3)	Specifies whether the type is a predefined type.
incomplete	character varying(3)	Specifies whether the type is incomplete.
final	character varying(3)	Not supported. Set it to NULL.
instantiable	character varying(3)	Not supported. Set it to NULL.
persistable	character varying(3)	Not supported. Set it to NULL.
supertype_owner	character varying(128)	Not supported. Set it to NULL.
supertype_name	character varying(128)	Not supported. Set it to NULL.
local_attributes	numeric	Not supported. Set it to NULL.
local_methods	numeric	Not supported. Set it to NULL.
typeid	raw	Not supported. Set it to NULL.