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:
|
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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
