boolean.

true or false.

int8.

8-bit signed integer, from -128 to 127.

int16.

16-bit signed integer, from -32 768 to 32 767.

int32.

32-bit signed integer, from -2 147 483 648 to 2 147 483 647.

int64.

64-bit signed integer, from -9 223 372 036 854 775 808 to 9 223 372 036 854 775 807.

int128.

128-bit signed integer, from -170 141 183 460 469 231 731 687 303 715 884 105 728 to 170 141 183 460 469 231 731 687 303 715 884 105 727.

uint8.

8-bit unsigned integer, from 0 to 255.

uint16.

16-bit unsigned integer, from 0 to 65 535.

uint32.

32-bit unsigned integer, from 0 to 4 294 967 295.

uint64.

64-bit unsigned integer, from 0 to 18 446 744 073 709 551 615.

uint128.

128-bit unsigned integer, from 0 to 340 282 366 920 938 463 463 374 607 431 768 211 455.

float32.

32-bit IEEE 754 floating-point value, approximately from 1.17549435e-38 to 3.40282347e+38.

float64.

64-bit IEEE 754 floating-point value, approximately from 4.9e-324 to 1.8e+308.

decimal.

Fixed-point decimal with precision P and scale S (e.g., decimal(5,2) is 123.45).

time.

Time of day, microsecond precision (e.g., 13:00:00).

timetz.

Time of day, microsecond precision, with time zone (e.g., 10:30:00+03).

date.

Calendar date (e.g., 2023-05-13).

timestamp.

Timestamp, microsecond precision (e.g., 2023-05-15 14:30:00).

timestamptz.

Timestamp, microsecond precision, with time zone (e.g., 2023-05-15 14:30:00+03).

timestamp_s.

Timestamp, second precision (e.g., 2023-05-15 14:30:00).

timestamp_ms.

Timestamp, millisecond precision (e.g., 2023-05-15 14:30:00.123).

timestamp_ns.

Timestamp, nanosecond precision (e.g., 2023-05-15 14:30:00.123456789).

interval.

Time interval in three different granularities: months, days, and milliseconds.

varchar.

Text (e.g., abcde, 12&^gh).

blob.

Binary data (e.g., PDF, image, video, audio).

json.

JSON (e.g., {"brand": "Ford","model": "Mustang","year": 1964}).

uuid.

Universally unique identifier (e.g., a81bc81b-dead-4e5d-abff-90865d1e13b1).