UserDefinedTypeStorage in sqlparser::ast

UserDefinedTypeStorage in sqlparser::ast - Rust

Enum UserDefinedTypeStorage

pub enum UserDefinedTypeStorage {
    Plain,
    External,
    Extended,
    Main,
}

Expand description

Storage specification for PostgreSQL user-defined base types.

Specifies the storage strategy for values of the data type:

plain: Prevents compression and out-of-line storage (for fixed-length types)
external: Allows out-of-line storage but not compression
extended: Allows both compression and out-of-line storage (default for most types)
main: Allows compression but discourages out-of-line storage

CREATE TYPE mytype (
    INPUT = in_func,
    OUTPUT = out_func,
    STORAGE = plain
);

No compression or out-of-line storage: STORAGE = plain

Out-of-line storage allowed, no compression: STORAGE = external

Both compression and out-of-line storage allowed: STORAGE = extended

Compression allowed, out-of-line discouraged: STORAGE = main