The following table shows the correspondence between data types in applications and data types in databases.
Data type on the server | Java data type | Data types prescribed by java.sql.Types |
|---|---|---|
character | String | java.sql.Types.CHAR |
national character | String | java.sql.Types.NCHAR |
character varying | String | java.sql.Types.VARCHAR |
national character varying | String | java.sql.Types.NVARCHAR |
text | String | java.sql.Types.VARCHAR |
bytea | byte[] | java.sql.Types.BINARY |
smallint | short | java.sql.Types.SMALLINT |
integer | int | java.sql.Types.INTEGER |
bigint | long | java.sql.Types.BIGINT |
smallserial | short | java.sql.Types.SMALLINT |
serial | int | java.sql.Types.INTEGER |
bigserial | long | java.sql.Types.BIGINT |
real | float | java.sql.Types.REAL |
double precision | double | java.sql.Types.DOUBLE |
numeric | java.math.BigDecimal | java.sql.Types.NUMERIC |
decimal | java.math.BigDecimal | java.sql.Types.DECIMAL |
money | String | java.sql.Types.OTHER |
date | java.sql.Date | java.sql.Types.DATE |
time with time zone | java.sql.Time | java.sql.Types.TIME |
time without time zone | java.sql.Time | java.sql.Types.TIME |
timestamp without time zone | java.sql.Timestamp | java.sql.Types.TIMESTAMP |
timestamp with time zone | java.sql.Timestamp | java.sql.Types.TIMESTAMP |
interval | org.postgresql.util.PGInterval | java.sql.Types.OTHER |
boolean | boolean | java.sql.Types.BIT |
bit | boolean | java.sql.Types.BIT |
bit varying | org.postgresql.util.Pgobject | java.sql.Types.OTHER |
oid | long | java.sql.Types.BIGINT |
xml | java.sql.SQLXML | java.sql.Types.SQLXML |
array | java.sql.Array | java.sql.Types.ARRAY |
uuid | java.util.UUID | java.sql.Types.OTHER |
point | org.postgresql.geometric.Pgpoint | java.sql.Types.OTHER |
box | org.postgresql.geometric.Pgbox | java.sql.Types.OTHER |
lseg | org.postgresql.geometric.Pglseg | java.sql.Types.OTHER |
path | org.postgresql.geometric.Pgpath | java.sql.Types.OTHER |
polygon | org.postgresql.geometric.PGpolygon | java.sql.Types.OTHER |
circle | org.postgresql.geometric.PGcircle | java.sql.Types.OTHER |
json | org.postgresql.util.PGobject | java.sql.Types.OTHER |
Network address type (inet,cidr,macaddr) | org.postgresql.util.PGobject | java.sql.Types.OTHER |
Types related to text searches (svector, tsquery) | org.postgresql.util.PGobject | java.sql.Types.OTHER |
Enumerated type | org.postgresql.util.PGobject | java.sql.Types.OTHER |
Composite type | org.postgresql.util.PGobject | java.sql.Types.OTHER |
Range type | org.postgresql.util.PGobject | java.sql.Types.OTHER |
All data types allow the use of the getString() method to acquire string values.
