GaussDB-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.
| 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. |
更多详情请参考GaussDB 文档中心：doc.hcs.huawei.com/db/zh-cn/ga…**
