Mysql -> PostgreSQL

OracleMySQLPostgreSQLJava
NUMBERdecimalnumericdouble
BigDecimal
整数intintegerInteger
smallintsmallint(int2)Integer
tinyint
bigintbigint
浮点数floatfloatFloat
doublefloat8Double
字符CHARcharcharString
VARCHAR2varcharvarcharString
日期datedateDate
datetimetimestampDate