PostgreSQL to SAP HANA mapping

AutoSync maps PostgreSQL object types to the following SAP HANA column types:

PostgreSQL object type SAP HANA column type
serial smallint
bigserial integer
int2 smallint
int4 integer
int8 bigint
numeric decimal
numeric_without_prec_scale varchar
float4 real
float8 double
money double
bytea varbinary
varchar varchar
bpchar varchar
text varchar
cidr varchar
inet varchar
macaddr varchar
macaddr8 varchar
bit varchar
uuid varchar
xml varchar
json nclob
jsonb nclob
tsvector varchar
tsquery varchar
timestamp timestamp
timestamptz timestamp
date date
time time
timetz time
interval varchar
point varchar
line varchar
lseg varchar
box varchar
path varchar
polygon varchar
circle varchar
geometry nclob
array varchar
composite varchar
range varchar
oid bigint
pg_lsn varchar
bool boolean
char varchar
name varchar
sl_timestamp timestamp