PostgreSQLソースデータ型 | Oracleターゲットデータ型 |
|---|---|
bigint | number(19) |
bit varying(precision), 1 <= p <= 83886080 | blob |
bit(precision), 1 <= p <= 83886080 | blob |
boolean | char(1 char) |
box | blob |
character varying(size), 1 <= s <= 1501 | char(s char), 4 <= s <= 2000 |
character varying(size), 2001 <= s <= 10485760 | clob |
character(size), 1 <= s <= 2000 | char(s char), 4 <= s <= 2000 |
character(size), 2100 <= s <= 10485760 | clob |
cidr | char(45 char) |
circle | blob |
date | date |
daterange | char(29 char) |
double precision | binary_double |
inet | char(45 char) |
int4range | char(25 char) |
int8range | char(43 char) |
integer | number(10) |
json | clob |
jsonb | clob |
line | blob |
lseg | blob |
macaddr | char(17 char) |
macaddr8 | char(23 char) |
money | number(19,2) |
numeric | clob |
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38 | number(p,s), 1 <= p <= 38, 0 <= s <= 38 |
numeric(p,s), 39 <= p <= 1000, 39 <= s <= 1000 | char(s char), 42 <= s <= 1003 |
numrange | clob |
path | blob |
point | blob |
polygon | blob |
real | binary_double |
smallint | number(5) |
time(precision) with time zone, 0 <= p <= 6 | char(s char), 48 <= s <= 55 |
time(precision) without time zone, 0 <= p <= 6 | timestamp(precision), 0 <= p <= 6 |
timestamp(precision) with time zone, 0 <= p <= 6 | timestamp(precision) with time zone, 0 <= p <= 6 |
timestamp(precision) without time zone, 0 <= p <= 0 | date |
timestamp(precision) without time zone, 1 <= p <= 6 | timestamp(precision), 1 <= p <= 6 |
tsrange | char(63 char) |
tstzrange | char(75 char) |
uuid | char(36 char) |
xml | clob |