Updated on 2024-05-07 GMT+08:00

MY_TYPE_ATTRS

MY_TYPE_ATTRS displays all types of attributes owned by the current user in the database. This view exists in the PG_CATALOG and SYS schemas and all users can access this view.

Table 1 MY_TYPE_ATTRS columns

Name

Type

Description

type_name

character varying(128)

Data type name.

attr_name

character varying(128)

Attribute name.

attr_type_mod

character varying(7)

Type modifier of an attribute:
  • REF
  • POINT

attr_type_owner

character varying(128)

Owner of an attribute type.

attr_type_name

character varying(128)

Name of an attribute type.

length

numeric

Length of the CHAR attribute, or the maximum length of the VARCHAR and character varying attribute

precision

numeric

Decimal precision of a number or DECIMAL attribute, or binary precision of a FLOAT attribute.

scale

numeric

Decimal places for a numeric or DECIMAL attribute.

character_set_name

character varying(44)

Character set name of an attribute (Char_CS or NCHAR_CS).

attr_no

numeric

Syntax order number or location (not used as an ID number) of an attribute specified in the type specification or CREATE TYPE statement.

inherited

character varying(3)

Specifies whether an attribute is inherited from a supertype.

  • YES: It is inherited from a supertype.
  • NO: It is not inherited from a supertype.