Supported PostgreSQL data types

ARRAY

ARRAY

java.lang.String

BIGINT

BIGINT

java.math.BigDecimal

BIT VARYING

VAR_BIT_STRING

not supported

BIT

BIT_STRING

java.lang.byte[]

BOOLEAN

BOOLEAN

java.math.BigDecimal

BOX

BOX

PGbox

BYTEA

CLOB

java.lang.byte[]

CHARACTER VARYING

VARCHAR

java.lang.String

CHARACTER

CHAR

java.lang.String

CIRCLE

CIRCLE

PGcircle

DATE

DATE

de.ubs.xdm.utils.core.HighPrecisionTimestamp

DATERANGE

VARCHAR

java.lang.String

DECIMAL

DECIMAL

java.math.BigDecimal

DOUBLE PRECISION

DOUBLE

java.math.BigDecimal

INT4RANGE

VARCHAR

java.lang.String

INT8RANGE

VARCHAR

java.lang.String

INTEGER

INTEGER

java.math.BigDecimal

INTERVAL

VARCHAR

java.lang.String

JSONB

JSONB

java.lang.String

JSON

JSON

java.lang.String

LINE

LINE

PGline

LSEG

LSEG

pGlseg

NUMRANGE

VARCHAR

java.lang.String

NUMERIC

NUMERIC

java.math.BigDecimal

OID

BLOB

java.sql.Blob

PATH

PATH

PGpath

POINT

POINT_TYPE

PGpoint

POLYGON

POLYGON

PGpolygon

REAL

REAL

java.math.BigDecimal

SMALLINT

SMALLINT

java.math.BigDecimal

TEXT

CLOB

java.sql.Clob

TIME WITHOUT TIME ZONE

TIME

de.ubs.xdm.utils.core.HighPrecisionTimestamp

TIMESTAMP WITH TIME ZONE

TIMESTAMP_WITH_TIMEZONE

de.ubs.xdm.utils.core.HighPrecisionTimestamp

TIMESTAMP WITHOUT TIME ZONE

TIMESTAMP

de.ubs.xdm.utils.core.HighPrecisionTimestamp

TSRANGE

VARCHAR

java.lang.String

TSTZRANGE

VARCHAR

java.lang.String

UUID

UUID

java.lang.String

XML

SQLXML

java.sql.Clob