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.