postgresql+java数据类型对照
PostgreSQL™ Java SE 8
date LocalDate
time LocalTime
timestamp without timezone LocalDateTime
timestamp with timezone OffsetDateTime
varchar String
text String
int2 Integer
int4 Integer
int8 Long
float4 Float
float8 Double
numeric BigDecimal
bool Boolean
date LocalDate
time LocalTime
timestamp without timezone LocalDateTime
timestamp with timezone OffsetDateTime
varchar String
text String
int2 Integer
int4 Integer
int8 Long
float4 Float
float8 Double
numeric BigDecimal
bool Boolean