Type Alias sea_schema::postgres::def::ColumnType

pub type ColumnType = Type;

Available on crate features postgres and def only.

Aliased Type§

enum ColumnType {
Show 50 variants    SmallInt,
    Integer,
    BigInt,
    Decimal(ArbitraryPrecisionNumericAttr),
    Numeric(ArbitraryPrecisionNumericAttr),
    Real,
    DoublePrecision,
    SmallSerial,
    Serial,
    BigSerial,
    Money,
    Varchar(StringAttr),
    Char(StringAttr),
    Text,
    Bytea,
    Timestamp(TimeAttr),
    TimestampWithTimeZone(TimeAttr),
    Date,
    Time(TimeAttr),
    TimeWithTimeZone(TimeAttr),
    Interval(IntervalAttr),
    Boolean,
    Point,
    Line,
    Lseg,
    Box,
    Path,
    Polygon,
    Circle,
    Cidr,
    Inet,
    MacAddr,
    MacAddr8,
    Bit(BitAttr),
    TsVector,
    TsQuery,
    Uuid,
    Xml,
    Json,
    JsonBinary,
    Array(ArrayDef),
    Int4Range,
    Int8Range,
    NumRange,
    TsRange,
    TsTzRange,
    DateRange,
    PgLsn,
    Unknown(String),
    Enum(EnumDef),
}

Variants§

SmallInt

16 bit integer

Integer

32 bit integer

BigInt

64 bit integer

Decimal(ArbitraryPrecisionNumericAttr)

User-specified precision number

Numeric(ArbitraryPrecisionNumericAttr)

User-specified precision number

Real

32 bit floating-point

DoublePrecision

64 bit floating-point

SmallSerial

16 bit autoincrementing integer

Serial

32 bit autoincrementing integer

BigSerial

64 bit autoincrementing integer

Money

Currency amount; 64 bits with a fractional precision determined by the database’s lc_monetary setting

Varchar(StringAttr)

Variable-length character array with limit

Char(StringAttr)

Fixed-length character array; blank padded

Text

Variable, unlimited length character array

Bytea

Variable length binary string

Timestamp(TimeAttr)

Date and time

TimestampWithTimeZone(TimeAttr)

Date

Date without time of day

Time(TimeAttr)

Time without date

TimeWithTimeZone(TimeAttr)

Interval(IntervalAttr)

Time interval

Boolean

One byte boolean value

Point

Point on a plane

Line

Infinite line

Lseg

Finite line segment

Box

Rectangular box

Path

Closed or open path

Polygon

Polygon (similar to a closed path)

Circle

Circle composed of a center point and radius

Cidr

IPv4 and IPv6 networks

Inet

IPPv4 and IPv6 hosts and networks

MacAddr

6 byte MAC address

MacAddr8

8 byte MAC address in EUI-64 format

Bit(BitAttr)

Fixed length bit string

TsVector

A sorted list of distinct lexemes which are words that have been normalized to merge different variants of the same word

TsQuery

A list of lexemes that are to be searched for, and can be combined using Boolean operators AND, OR, and NOT, as well as a phrase search operation

Uuid

A universally unique identifier as defined by RFC 4122, ISO 9834-8:2005, and related standards

Xml

XML data checked for well-formedness and with additional support functions

Json

JSON data checked for validity and with additional functions

JsonBinary

JSON data stored in a decomposed binary format that can be subscripted and used in indexes

Array(ArrayDef)

Variable-length multidimensional array

Int4Range

Range of an integer

Int8Range

Range of a bigint

NumRange

Range of a numeric

TsRange

Range of a timestamp without time zone

TsTzRange

Range of a timestamp with time zone

DateRange

Range of a date

PgLsn

A log sequence number

Unknown(String)

Enum(EnumDef)

Defines an PostgreSQL