Updated on 2025-07-15 GMT+08:00

ADM_TYPE_ATTRS

ADM_TYPE_ATTRS displays the attributes of the current database object type.

Table 1 ADM_TYPE_ATTRS columns

Name

Type

Description

owner

oid

Owner of the type.

type_name

name

Data type name.

attr_name

name

Column name.

attr_type_mod

integer

Type-specific data supplied at the table creation time (for example, the maximum length of a varchar column). This column is used as the third parameter when passing to type-specific input functions and length coercion functions. The value will generally be –1 for types that do not need ATTTYPMOD.

attr_type_owner

oid

Owner of an attribute of this type.

attr_type_name

name

Data type attribute name.

length

smallint

Number of bytes in the internal representation of the type for a fixed-size type. It is a negative number for a variable-length type.

  • The value -1 indicates a "varlena" type (one that has a length word).
  • The value -2 indicates a NULL-terminated C string.

precision

integer

Precision of the numeric type.

scale

integer

Range of the numeric type.

character_set_name

character(1)

Character set name of an attribute (c or n).

attr_no

smalllint

Attribute number

inherited

character(1)

Specifies whether the attribute is inherited from the super type (Y or N).