PostgreSQLソースデータ型 | Amazon Redshiftターゲットデータ型 |
|---|---|
bigint | int8 |
bit varying(1) | boolean |
bit varying(precision), 2 <= p <= 83886080 | binary varying(size), 1 <= size <= 1024000 |
bit(1) | boolean |
bit(precision), 2 <= p <= 83886080 | binary varying(size), 1 <= size <= 1024000 |
boolean | boolean |
box | binary varying(115) |
character varying(size), 1 <= size <= 10485760 | character varying(size), 4 <= size <= 65535 |
character(size), 1 <= size <= 10485760 | character varying(size), 4 <= size <= 65535 |
cidr | character varying(45) |
circle | binary varying(87) |
date | date |
daterange | character varying(29) |
double precision | double precision |
inet | character varying(45) |
int4range | character varying(25) |
int8range | character varying(43) |
integer | integer |
json | super |
jsonb | super |
line | binary varying(85) |
lseg | binary varying(117) |
macaddr | character varying(17) |
macaddr8 | character varying(23) |
money | numeric(20,2) |
numeric | character varying(65535) |
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37 | numeric(p,s), 1 <= p <= 38, 0 <= s <= 37 |
numeric(p,s), 38 <= p <= 1000, 38 <= s <= 1000 | character varying(size), 41 <= size <= 1003 |
numrange | character varying(65535) |
path | binary varying(1024000) |
point | binary varying(57) |
polygon | binary varying(1024000) |
real | real |
smallint | smallint |
time(precision) with time zone, 0 <= p <= 6 | timetz |
time(precision) without time zone, 0 <= p <= 6 | time |
timestamp(precision) with time zone, 0 <= p <= 6 | timestamp with time zone |
timestamp(precision) without time zone, 0 <= p <= 6 | timestamp |
tsrange | character varying(63) |
tstzrange | character varying(75) |
uuid | character(36) |
xml | character varying(65535) |