Striim 3.9.4 / 3.9.5 documentation

PostgreSQLReader data type support and conversion reference

Array types are not supported.

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

date

DateTime

double precision

double

inet

string

integer

integer

int2

short

int4

integer

int8

long

integer

integer

interval

string

json

string

jsonb

unsupported

line

unsupported

lseg

unsupported

macaddr

string

macaddr8

string

money

string

numeric

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

timestamp with time zone

datetime

tsquery

unsupported

tsvector

unsupported

txid_snapshot

string

uuid

string

xml

string