35.60. user_defined_types
user_defined_types
The view user_defined_types currently contains all composite types defined in the current database.
Only those types are shown that the current user has access to (by way of being the owner or having some privilege).
SQL knows about two kinds of user-defined types: structured types (also known as composite types in PostgreSQL) and distinct types (not implemented in PostgreSQL).
To be future-proof, use the column user_defined_type_category to differentiate between these.
Other user-defined types such as base types and enums, which are PostgreSQL extensions, are not shown here.
For domains, see domains instead.
Column Type Description |
|---|
user_defined_type_catalog Name of the database that contains the type (always the current database) |
user_defined_type_schema Name of the schema that contains the type |
user_defined_type_name Name of the type |
user_defined_type_category Currently always |
is_instantiable Applies to a feature not available in PostgreSQL |
is_final Applies to a feature not available in PostgreSQL |
ordering_form Applies to a feature not available in PostgreSQL |
ordering_category Applies to a feature not available in PostgreSQL |
ordering_routine_catalog Applies to a feature not available in PostgreSQL |
ordering_routine_schema Applies to a feature not available in PostgreSQL |
ordering_routine_name Applies to a feature not available in PostgreSQL |
reference_type Applies to a feature not available in PostgreSQL |
data_type Applies to a feature not available in PostgreSQL |
character_maximum_length Applies to a feature not available in PostgreSQL |
character_octet_length Applies to a feature not available in PostgreSQL |
character_set_catalog Applies to a feature not available in PostgreSQL |
character_set_schema Applies to a feature not available in PostgreSQL |
character_set_name Applies to a feature not available in PostgreSQL |
collation_catalog Applies to a feature not available in PostgreSQL |
collation_schema Applies to a feature not available in PostgreSQL |
collation_name Applies to a feature not available in PostgreSQL |
numeric_precision Applies to a feature not available in PostgreSQL |
numeric_precision_radix Applies to a feature not available in PostgreSQL |
numeric_scale Applies to a feature not available in PostgreSQL |
datetime_precision Applies to a feature not available in PostgreSQL |
interval_type Applies to a feature not available in PostgreSQL |
interval_precision Applies to a feature not available in PostgreSQL |
source_dtd_identifier Applies to a feature not available in PostgreSQL |
ref_dtd_identifier Applies to a feature not available in PostgreSQL |
: user_defined_types Columns