別紙： 組み込みデータ型対応表（Oracle-PostgreSQL）

 Oracle-PostgreSQL

Oracle VARCHAR2

NVARCHAR2 CHAR

NCHAR LONG CLOB NCLOB NUMBER

FLOAT

BINARY_FLOAT BINARY_DOUBLE DATE

TIMESTAMP TIMESTAMP WITH TIMEZONE

TIMESTAMP WITH LOCAL TIMEZONE INTERVAL YEAR TO MONTH INTERVAL DAY TO SECOND RAW LONG RAW BLOB

BFILE ROWID UROWID

byte char char byte char char

4000 4000 4000 2000 2000 2000 2G-1 4G-1 4G-1 (1038)(10-84127)

(2126)

-4712/01/01 9999/12/31

byte

DATE

2000 2G-1 4G-1 4G-1 ()

PostgreSQL varchar(n) varchar(n) varchar(n) char(n) char(n) char(n) text text text decimal numeric smallint integer bigint real double precision float

real double precision timestamp date timestamp timestamp [ (p) ] with time zone timestamp [ (p) ] with time zone interval [ fields ] [ (p) ] interval [ fields ] [ (p) ] bytea bytea bytea

2

4

8

4

8 48

4 8 8 4 8 8 8 12 12

1

(1GB) (1GB) (1GB) 13107216383 13107216383 (-32768+32767) (-2147483648+2147483647) (-92233720368547758089223372036854775807) 6 15 253

6 15 4713 BC294276 AD114 PostgreSQLdate 4713 BC294276 AD114 4713 BC294276 AD114 4713 BC294276 AD114 -178000000178000000114 -178000000178000000114 (1GB) (1GB) (1GB)

PostgreSQLOracle 8iDB9i PostgreSQLOracle 8iDB9i 1GB

PostgreSQL ()l integer, bigint, numeric numeric numeric PostgreSQL numeric integer, bigint realdouble precision

PostgreSQLfloat(1)float(24)realfloat(25)float(53) double precisionfloatdouble precision

OracleDATEPostgreSQL

1GB

1

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download