Type Alias sea_schema::postgres::def::ColumnType
source · pub type ColumnType = Type;
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