Data Types

Complete reference for DeltaForge data types: 58 entries grouped by category with syntax and semantics. Mirror of the interactive documentation at docs.deltaforge.org.

Binary

Name	Summary
`BINARY`
`BIT`
`VARBIT`

Boolean

Name	Summary
`BOOLEAN`

Complex

Name	Summary
`ARRAY`
`BOX`
`CIRCLE`
`DATERANGE`
`INT4RANGE`
`INT8RANGE`
`JSON`
`JSONB`
`LINE`
`LSEG`
`MAP`
`NUMRANGE`
`PATH`
`POINT`
`POLYGON`
`RECORD`
`REFCURSOR`
`STRUCT`
`TSRANGE`
`TSTZRANGE`
`VOID`

Numeric

Name	Summary
`BIGINT`
`BIGSERIAL`
`DECIMAL`
`DOUBLE`
`FLOAT`
`INT`
`MONEY`
`OID`
`REAL`
`SERIAL`
`SMALLINT`
`SMALLSERIAL`
`TINYINT`

String

Name	Summary
`CHAR`
`CIDR`
`INET`
`MACADDR`
`MACADDR8`
`REGCLASS`
`REGPROC`
`REGTYPE`
`STRING`
`TSQUERY`
`TSVECTOR`
`UUID`
`VARCHAR`
`XML`

Temporal

Name	Summary
`DATE`
`INTERVAL`
`TIME`
`TIME WITH TIME ZONE`
`TIMESTAMP`
`TIMESTAMP_NTZ`