Mass Ingestion
- Mass Ingestion
- 所有产品
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)
|