Mass Ingestion

Back Next

PostgreSQL Source and Amazon Redshift Target

The following table identifies the recommended data-type mappings for Mass Ingestion Databases configurations with a PostgreSQL source and an Amazon Redshift target:

PostgreSQL Source Data Type	Amazon Redshift Target Data Type
bigint	bigint
bit varying(`precision`), 1 <= p <= 83700001	character varying(`size`), 2 <= s <= 65535
bit(`precision`), 1 <= p <= 83886080	character varying(`size`), 2 <= s <= 65535
boolean	boolean
box	geometry
character varying(`size`), 1 <= s <= 10485760	character varying(`size`), 4 <= s <= 65535
character(`size`), 1 <= s <= 10485760	character varying(`size`), 4 <= s <= 65535
cidr	character varying(45)
circle	geometry
date	date
daterange	character varying(29)
double precision	double precision
inet	character varying(45)
int4range	character varying(25)
int8range	character varying(43)
integer	integer
line	geometry
lseg	geometry
macaddr	character varying(17)
macaddr8	character varying(23)
money	numeric(20,2)
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37	numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
numeric(p,s), 38 <= p <= 999, 38 <= s <= 998	character varying(`size`), 41 <= s <= 1001
numrange	character varying(65535)
path	geometry
point	geometry
polygon	geometry
real	real
smallint	smallint
time(`precision`) with time zone, 0 <= p <= 6	time with time zone
time(`precision`) without time zone, 0 <= p <= 6	time without time zone
timestamp(`precision`) with time zone, 0 <= p <= 6	timestamp with time zone
timestamp(`precision`) without time zone, 0 <= p <= 6	timestamp without time zone
tsrange	character varying(63)
tstzrange	character varying(75)
uuid	character(36)