Striim 3.9.7 documentation

PostgreSQLReader data type support and correspondence

PostgreSQL type

Striim type

bigint

long

bigserial

long

bit

string

bit varying

string

boolean

short

bytea

string

character

string

character varying

string

cidr

string

circle

unsupported

composite type

string

date

DateTime

daterange

string

double precision

double

inet

string

integer

integer

int2

short

int4

integer

int4range

string

int8

long

int8range

string

integer

integer

interval

string

json

string

jsonb

string

line

unsupported

lseg

unsupported

macaddr

string

macaddr8

string

money

string

name (system identifier)

string

numeric

string

numrange

string

path

unsupported

pg_lan

string

point

unsupported

polygon

unsupported

real

float

smallint

short

smallserial

short

serial

integer

text

string

time

string

time with time zone

string

timestamp

datetime

tsrange

string

timestamp with time zone

datetime

tstzrange

string

tsquery

unsupported

tsvector

unsupported

txid_snapshot

string

uuid

string

xml

string