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 |