一括取り込みデータベース

前へ次へ

OracleソースとPostgreSQLターゲット

次の表は、OracleソースとPostgreSQLターゲットを使用した一括取り込みデータベース設定の推奨データ型マッピングを示しています。

Oracleソースデータ型	PostgreSQLターゲットデータ型
binary_double	double precision
binary_float	real
blob	bytea
char(s byte), 1 <= s <= 2000	character varying(`size`), 1 <= size <= 500
char(s char), 1 <= s <= 2000	character varying(`size`), 1 <= size <= 2000
clob	text
date	timestamp(`precision`) without time zone, 0 <= p <= null
float(`precision`), 1 <= p <= 126	character varying(255)
integer	character varying(255)
long raw	bytea
long(2147483648 byte)	text
nchar(s char), 1 <= s <= 2000	character varying(`size`), 1 <= s <= 2000
nclob	text
number	character varying(255)
number(*,s), -84 <= s <= 127	character varying(255)
number(p,s), 1 <= p <= 38, -84 <= s <= 127	numeric(p,s), 0 <= p <= 127, 1 <= s <= 127
nvarchar2(s char), 1 <= s <= 4000	character varying(`size`), 1 <= s <= 4000
raw(`size`), 1 <= s <= 2000	bytea
rowid	character(18)
timestamp(`precision`) with time zone, 0 <= p <= 6	timestamp(`precision`) with time zone, 0 <= p <= 6
timestamp(`precision`) with time zone, 7 <= p <= 9	character varying(`size`), 67 <= size <= 69
timestamp(`precision`), 1 <= p <= 6	timestamp(`precision`) without time zone, 1 <= p <= 6
timestamp(`precision`), 7 <= p <= 9	character varying(`size`), 27 <= size <= 29
varchar2(s byte), 1 <= s <= 4000	character varying(`size`), 1 <= size <= 1000
varchar2(s char), 1 <= s <= 4000	character varying(`size`), 1 <= size <= 4000