PostgreSQL to MySQL mapping
AutoSync maps PostgreSQL object types to the following MySQL column types:
PostgreSQL object type | MySQL column type |
---|---|
serial |
SMALLINT |
bigserial |
INT |
int2 |
SMALLINT |
int4 |
INT |
int8 |
BIGINT |
numeric |
DECIMAL |
numeric_without_prec_scale |
VARCHAR |
float4 |
FLOAT |
float8 |
DOUBLE |
money |
DOUBLE |
bytea |
BLOB |
varchar |
VARCHAR |
bpchar |
VARCHAR |
text |
VARCHAR |
cidr |
VARCHAR |
inet |
VARCHAR |
macaddr |
VARCHAR |
macaddr8 |
VARCHAR |
bit |
VARCHAR |
uuid |
VARCHAR |
xml |
VARCHAR |
json |
JSON |
jsonb |
JSON |
tsvector |
VARCHAR |
tsquery |
VARCHAR |
timestamp |
DATETIME |
timestamptz |
DATETIME |
date |
DATE |
time |
TIME |
timetz |
TIME |
interval |
VARCHAR |
point |
VARCHAR |
line |
VARCHAR |
lseg |
VARCHAR |
box |
VARCHAR |
path |
VARCHAR |
polygon |
VARCHAR |
circle |
VARCHAR |
geometry |
JSON |
array |
VARCHAR |
composite |
VARCHAR |
range |
VARCHAR |
oid |
INT UNSIGNED |
pg_lsn |
VARCHAR |
bool |
BIT |
char |
CHAR |
name |
VARCHAR |
sl_timestamp |
DATETIME |