PostgreSQL Type

DTS Type

boolean

BOOLEAN

character

STRING

char

STRING

varchar

STRING

character varying

STRING

text

STRING

smallint

INT16

smallserial

INT16

int

INT32

serial

INT32

bigint

INT64

bigserial

INT64

bytea

BYTE_VECTOR

real

FLOAT

double precision

DOUBLE

numeric

DECIMAL

decimal

DECIMAL

date

DATE

time

TIME

time with timezone

TIME

time without timezone

TIME

timestamp

DATE_TIME

timestamp with timezone

DATE_TIME

timestamp without timezone

DATE_TIME

interval

STRING

uuid

STRING

cidr

STRING

inet

STRING

macaddr

STRING

macaddr8

STRING

bit

STRING

bit varying

STRING

tsvector

STRING

tsquery

STRING

xml

STRING

json

STRING

jsonb

STRING

money

STRING

geometry

DTS_GEOMETRY

box

DTS_GEOMETRY

box2d

DTS_GEOMETRY

box2df

DTS_GEOMETRY

box3d

DTS_GEOMETRY

circle

DTS_GEOMETRY

line

DTS_GEOMETRY

lseg

DTS_GEOMETRY

path

DTS_GEOMETRY

point

DTS_GEOMETRY

polygon

DTS_GEOMETRY