boolean

true or false

int8

Integer, from -128 to 127

int16

Integer, from -32,768 to 32,767

int32

Integer, from -2 147 483 648 to 2 147 483 647

int64

Integer, from -9 223 372 036 854 775 808 to 9 223 372 036 854 775 807

unit8

Integer, from 0 to 255

unit16

Integer, from 0 to 65,535

unit32

Integer, from 0 to 4 294 967 295

unit64

Integer, from 0 to 18 446 744 073 709 551 615

float32

Fraction, approximately from 1.17549435E-38 to 3.40282347E+38.

Precision: 6–7 numbers after the comma

float64

Float, approximately from 4.9E-324 to 1.8E+308.

Precision: 14–15 numbers after the comma

decimal

Decimal (e.g., decimal(5,2) is 123.45 or 999.99)

time

Time (e.g., 13:00:00)

timez

Time with timezone (e.g., 10:30:00+03)

date

Date (e.g., 2023-05-13)

timestamp

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

timestamptz

Timestamp with timezone (e.g., 2023-05-15 14:30:00+03)

timestamp_s

Second-precision timestamp (e.g., 2023-05-15 14:30:00+03)

timestamp_ms

Millisecond-precison timestamp (e.g., 2023-05-15 14:30:00.123)

timestamp_ns

Nanosecond-precision timestamp (e.g., 2023-05-15 14:30:00.123456789)

interval

Time interval (e.g., 1 day, 1 hour, 1 minute)

varchar

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

blob

Blob (e.g., PDF, image, video, audio)

json

JSON (e.g., {"brand": "Apple","model": "MacBook Pro","screen_size": 13.3,"ram": "16GB"})

json

UUID (e.g., a81bc81b-dead-4e5d-abff-90865d1e13b1)