ADM_TYPE_ATTRS

ADM_TYPE_ATTRS displays the attributes of the current database object type. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schema.

**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, which records the type name after conversion.
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). c: CHAR_CS. n: NCHAR_CS.
attr_no	smallint	Attribute number
inherited	character(1)	Specifies whether the attribute is inherited from the super type (Y or N).
attr_length	integer	Type-specific data supplied at the table creation time (for example, the maximum length of a varchar column). The raw type is not recorded due to kernel implementation.