Enum UserDefinedTypeSqlDefinitionOption 

pub enum UserDefinedTypeSqlDefinitionOption {
    Input(ObjectName),
    Output(ObjectName),
    Receive(ObjectName),
    Send(ObjectName),
    TypmodIn(ObjectName),
    TypmodOut(ObjectName),
    Analyze(ObjectName),
    Subscript(ObjectName),
    InternalLength(UserDefinedTypeInternalLength),
    PassedByValue,
    Alignment(Alignment),
    Storage(UserDefinedTypeStorage),
    Like(ObjectName),
    Category(char),
    Preferred(bool),
    Default(Expr),
    Element(DataType),
    Delimiter(String),
    Collatable(bool),
}

Options for PostgreSQL CREATE TYPE ... (<options>) statement (base type definition).

Base types are the lowest-level data types in PostgreSQL. To define a new base type, you must specify functions that convert it to and from text representation, and optionally binary representation and other properties.

Note: This syntax uses parentheses directly after the type name, without the AS keyword.

PostgreSQL Documentation

See: https://www.postgresql.org/docs/current/sql-createtype.html

Examples

CREATE TYPE complex (
    INPUT = complex_in,
    OUTPUT = complex_out,
    INTERNALLENGTH = 16,
    ALIGNMENT = double
);

Variants

Input(ObjectName)

Function to convert from external text representation to internal: INPUT = input_function

Output(ObjectName)

Function to convert from internal to external text representation: OUTPUT = output_function

Receive(ObjectName)

Function to convert from external binary representation to internal: RECEIVE = receive_function

Send(ObjectName)

Function to convert from internal to external binary representation: SEND = send_function

TypmodIn(ObjectName)

Function to convert type modifiers from text array to internal form: TYPMOD_IN = type_modifier_input_function

TypmodOut(ObjectName)

Function to convert type modifiers from internal to text form: TYPMOD_OUT = type_modifier_output_function

Analyze(ObjectName)

Function to compute statistics for the data type: ANALYZE = analyze_function

Subscript(ObjectName)

Function to handle subscripting operations: SUBSCRIPT = subscript_function

InternalLength(UserDefinedTypeInternalLength)

Internal storage size in bytes, or VARIABLE for variable-length: INTERNALLENGTH = { internallength | VARIABLE }

PassedByValue

Indicates values are passed by value rather than by reference: PASSEDBYVALUE

Alignment(Alignment)

Storage alignment requirement (1, 2, 4, or 8 bytes): ALIGNMENT = alignment

Storage(UserDefinedTypeStorage)

Storage strategy for varlena types: STORAGE = storage

Like(ObjectName)

Copy properties from an existing type: LIKE = like_type

Category(char)

Type category for implicit casting rules (single char): CATEGORY = category

Preferred(bool)

Whether this type is preferred within its category: PREFERRED = preferred

Default(Expr)

Default value for the type: DEFAULT = default

Element(DataType)

Element type for array types: ELEMENT = element

Delimiter(String)

Delimiter character for array value display: DELIMITER = delimiter

Collatable(bool)

Whether the type supports collation: COLLATABLE = collatable

Trait Implementations

impl Clone for UserDefinedTypeSqlDefinitionOption

fn clone(&self) -> UserDefinedTypeSqlDefinitionOption

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for UserDefinedTypeSqlDefinitionOption

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for UserDefinedTypeSqlDefinitionOption

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Display for UserDefinedTypeSqlDefinitionOption

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Hash for UserDefinedTypeSqlDefinitionOption

fn hash<__H: Hasher>(&self, state: &mut __H)

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)

where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

impl Ord for UserDefinedTypeSqlDefinitionOption

fn cmp(&self, other: &UserDefinedTypeSqlDefinitionOption) -> Ordering

This method returns an Ordering between self and other.

fn max(self, other: Self) -> Self

where Self: Sized,

Compares and returns the maximum of two values.

fn min(self, other: Self) -> Self

where Self: Sized,

Compares and returns the minimum of two values.

fn clamp(self, min: Self, max: Self) -> Self

where Self: Sized,

Restrict a value to a certain interval.

impl PartialEq for UserDefinedTypeSqlDefinitionOption

fn eq(&self, other: &UserDefinedTypeSqlDefinitionOption) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl PartialOrd for UserDefinedTypeSqlDefinitionOption

fn partial_cmp( &self, other: &UserDefinedTypeSqlDefinitionOption, ) -> Option<Ordering>

This method returns an ordering between self and other values if one exists.

fn lt(&self, other: &Rhs) -> bool

Tests less than (for self and other) and is used by the < operator.

fn le(&self, other: &Rhs) -> bool

Tests less than or equal to (for self and other) and is used by the <= operator.

fn gt(&self, other: &Rhs) -> bool

Tests greater than (for self and other) and is used by the > operator.

fn ge(&self, other: &Rhs) -> bool

Tests greater than or equal to (for self and other) and is used by the >= operator.

impl Serialize for UserDefinedTypeSqlDefinitionOption

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl Visit for UserDefinedTypeSqlDefinitionOption

fn visit<V: Visitor>(&self, visitor: &mut V) -> ControlFlow<V::Break>

impl VisitMut for UserDefinedTypeSqlDefinitionOption

fn visit<V: VisitorMut>(&mut self, visitor: &mut V) -> ControlFlow<V::Break>

impl Eq for UserDefinedTypeSqlDefinitionOption

impl StructuralPartialEq for UserDefinedTypeSqlDefinitionOption