The user_defined_types view provides information about composite types defined by users.
| Column name | Data type | Description |
|---|---|---|
user_defined_type_catalog |
sql_identifier |
The name of the current database containing the type. |
user_defined_type_schema |
sql_identifier |
The name of the schema containing the type. |
user_defined_type_name |
sql_identifier |
The name of the type. |
user_defined_type_category |
character_data |
The category of the type. Always STRUCTURED. |
is_instantiable |
yes_or_no |
Specifies whether the type is instantiable. Applies to a feature that is not available in PostgreSQL. |
is_final |
yes_or_no |
Specifies whether the type is final. Applies to a feature that is not available in PostgreSQL. |
ordering_form |
character_data |
The ordering form. Applies to a feature that is not available in PostgreSQL. |
ordering_category |
character_data |
The ordering category. Applies to a feature that is not available in PostgreSQL. |
ordering_routine_catalog |
sql_identifier |
The catalog of the ordering routine. Applies to a feature that is not available in PostgreSQL. |
ordering_routine_schema |
sql_identifier |
The schema of the ordering routine. Applies to a feature that is not available in PostgreSQL. |
ordering_routine_name |
sql_identifier |
The name of the ordering routine. Applies to a feature that is not available in PostgreSQL. |
reference_type |
character_data |
The reference type. Applies to a feature that is not available in PostgreSQL. |
data_type |
character_data |
The data type. Applies to a feature that is not available in PostgreSQL. |
character_maximum_length |
cardinal_number |
The maximum character length. Applies to a feature that is not available in PostgreSQL. |
character_octet_length |
cardinal_number |
The maximum character octet length. Applies to a feature that is not available in PostgreSQL. |
character_set_catalog |
sql_identifier |
The catalog of the character set. Applies to a feature that is not available in PostgreSQL. |
character_set_schema |
sql_identifier |
The schema of the character set. Applies to a feature that is not available in PostgreSQL. |
character_set_name |
sql_identifier |
The name of the character set. Applies to a feature that is not available in PostgreSQL. |
collation_catalog |
sql_identifier |
The catalog of the collation. Applies to a feature that is not available in PostgreSQL. |
collation_schema |
sql_identifier |
The schema of the collation. Applies to a feature that is not available in PostgreSQL. |
collation_name |
sql_identifier |
The name of the collation. Applies to a feature that is not available in PostgreSQL. |
numeric_precision |
cardinal_number |
The numeric precision. Applies to a feature that is not available in PostgreSQL. |
numeric_precision_radix |
cardinal_number |
The numeric precision radix. Applies to a feature that is not available in PostgreSQL. |
numeric_scale |
cardinal_number |
The numeric scale. Applies to a feature that is not available in PostgreSQL. |
datetime_precision |
cardinal_number |
The datetime precision. Applies to a feature that is not available in PostgreSQL. |
interval_type |
character_data |
The interval type. Applies to a feature that is not available in PostgreSQL. |
interval_precision |
cardinal_number |
The interval precision. Applies to a feature that is not available in PostgreSQL. |
source_dtd_identifier |
sql_identifier |
The identifier of the source DTD. Applies to a feature that is not available in PostgreSQL. |
ref_dtd_identifier |
sql_identifier |
The identifier of the referenced DTD. Applies to a feature that is not available in PostgreSQL. |