Type reference
jed's scalar types. This table is generated at build time from the canonical spec data (spec/types/scalars.toml), so it always matches the engine. Types marked expression only exist as expression/literal types but cannot yet be a column type.
| Type | Aliases | Family | Storable | Width | Range |
|---|---|---|---|---|---|
| i16 | smallint, int2 | integer | yes | 16-bit | -32768 … 32767 |
| i32 | int, integer, int4 | integer | yes | 32-bit | -2147483648 … 2147483647 |
| i64 | bigint, int8 | integer | yes | 64-bit | -9223372036854775808 … 9223372036854775807 |
| boolean | bool | boolean | yes | — | — |
| text | varchar, character varying, string | text | yes | — | — |
| decimal | numeric, dec | decimal | yes | — | — |
| bytea | — | bytea | yes | — | — |
| uuid | — | uuid | yes | — | — |
| timestamp | timestamp without time zone | timestamp | yes | — | — |
| timestamptz | timestamp with time zone | timestamptz | yes | — | — |
| interval | — | interval | yes | — | — |
| f32 | real, float4 | float | yes | — | — |
| f64 | double precision, float, float8 | float | yes | — | — |
| date | — | date | yes | — | — |
| json | — | json | yes | — | — |
| jsonb | — | jsonb | yes | — | — |
| jsonpath | — | jsonpath | expression only | — | — |