Last updated:|... min read
| PostgreSQL Data Types | Destination Data Type |
|---|---|
| int, int2, int4, smallint, integer, serial, serial2, serial4 | int |
| bigint, bigserial, int8, serial8 | bigint |
| float, float4, real, numeric | float |
| double precision, float8 | double |
| boolean | boolean |
| date, timestamp without time zone, timestamp with time zone | timestamptz |
| box, bpchar, char, character, character varying, json, jsonb, jsonpath, name, numrange, path, text, tid, tsquery, tsrange, tstzrange, uuid, varbit, varchar, xml, inet, bit, int2vector, daterange, time with time zone, time without time zone | string |
timestamptz timezone
OLake always ingests timestamp data in UTC format, independent of the source timezone.