The USER_TYPES view provides the information about all object types owned by the current user.

Parameter Type Description
schema_name TEXT The name of the schema in which the type is defined.
type_name TEXT The name of the type.
type_oid OID The object identifier (OID) of the type.
typecode TEXT The typecode of the type. Valid values:
attributes INTEGER The number of properties in the type.