PostgreSQLソースデータ型 | Microsoft Azure Synapse Analyticsターゲットデータ型 |
|---|---|
bigint | bigint |
bit varying(1) | varbinary(size), 1 <= size <= max |
bit varying(precision), 2 <= p <= 83886080 | varbinary(size), 1 <= size <= max |
bit(1) | bit |
bit(precision), 2 <= p <= 64000 | binary(size), 1 <= size <= 8000 |
bit(precision), 64001 <= p <= 83886080 | varbinary(max) |
boolean | bit |
box | varbinary(115) |
character varying(size), 1 <= size <= 10485760 | varchar(size), 4 <= size <= max |
character(size), 1 <= size <= 10485760 | varchar(size), 4 <= size <= max |
cidr | varchar(45) |
circle | varbinary(87) |
date | date |
daterange | varchar(29) |
double precision | float |
inet | varchar(45) |
int4range | varchar(25) |
int8range | varchar(43) |
integer | int |
json | varchar(max) |
jsonb | varchar(max) |
line | varbinary(85) |
lseg | varbinary(117) |
macaddr | varchar(17) |
macaddr8 | varchar(23) |
money | decimal(19,2) |
numeric | number |
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38 | decimal(p,s), 1 <= p <= 38, 0 <= s <= 38 |
numeric(p,s), 39 <= p <= 1000, 39 <= s <= 1000 | varchar(size), 42 <= s <= 1003 |
numrange | varchar(max) |
path | varbinary(max) |
point | varbinary(57) |
polygon | varbinary(max) |
real | real |
smallint | smallint |
time(precision) with time zone, 0 <= p <= 6 | datetimeoffset(precision), 0 <= p <= 6 |
time(precision) without time zone, 0 <= p <= 6 | time(precision), 0 <= p <= 6 |
timestamp(precision) with time zone, 0 <= p <= 6 | datetimeoffset(precision), 0 <= p <= 6 |
timestamp(precision) without time zone, 0 <= p <= 6 | datetime2(precision), 0 <= p <= 6 |
tsrange | varchar(63) |
tstzrange | varchar(75) |
uuid | uniqueidentifier |
xml | varchar(max) |