PostgreSQL to Redshift mapping

AutoSync maps PostgreSQL object types to the following Redshift column types:


PostgreSQL object type	Redshift column type
`serial`	`smallint`
`bigserial`	`integer`
`int2`	`smallint`
`int4`	`integer`
`int8`	`bigint`
`numeric`	`decimal`
`numeric_without_prec_scale`	`varchar`
`float4`	`real`
`float8`	`double precision`
`money`	`double precision`
`bytea`	`varbyte`
`varchar`	`varchar`
`bpchar`	`varchar`
`text`	`varchar`
`cidr`	`varchar`
`inet`	`varchar`
`macaddr`	`varchar`
`macaddr8`	`varchar`
`bit`	`varchar`
`uuid`	`varchar`
`xml`	`varchar`
`json`	`varchar`
`jsonb`	`varchar`
`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`	`varchar`
`array`	`varchar`
`composite`	`varchar`
`range`	`varchar`
`oid`	`bigint`
`pg_lsn`	`varchar`
`bool`	`boolean`
`char`	`char`
`name`	`varchar`
`sl_timestamp`	`timestamptz`