MY_TYPE_ATTRS
MY_TYPE_ATTRS displays all types of attributes owned by the current user in the database. This view exists in both PG_CATALOG and SYS schema 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:
|
| 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.
|
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
