PostgreSQL
Data type |
RapidClipse default mapping |
Generated Javacode (example) |
MONEY Currency amount Range: -92233720368547758.08 to +92233720368547758.07 Storage: 8 bytes |
|
|
BIGINT Large-range integer Range: -9223372036854775808 to 9223372036854775807 Storage: 8 bytes |
Hibernate default mapping |
|
BIGSERIAL Large autoincrementing integer 1 to 9223372036854775807 Storage: 8 bytes |
Hibernate default mapping |
|
BOLEAN PostgreSQL provides the standard SQL type boolean. Boolean can have one of only two states: "true" or false". A third state, "unknown", is represented by the SQL null value. |
Hibernate default mapping |
|
BYTEA A variable-length binary string. Storage: 1 or 4 bytes plus the actual binary string. |
Hibernate default mapping |
|
CHARACTER Character string with fixed-length and blank padding. |
|
|
CHARACTER VARYING Character string with variable-length with limit. |
Hibernate default mapping |
|
DATE Storage: 4 bytes Range: 4713 BC - 5874897 AD Resolution: 1 day |
Hibernate default mapping |
|
DOUBLE PRECISION A user-specified precision, exact number Range: 15 decimal digits precision Storage: 8 bytes |
Hibernate default mapping |
|
INTEGER A normal integer Range: -2147483648 to +2147483647 Storage: 4 bytes |
Hibernate default mapping |
|
NUMERIC A user-specified precision, exact number Range: no limit Storage: variable |
Hibernate default mapping |
|
REAL A user-specified precision, exact number Range: 6 decimal digits precision Storage: 4 bytes |
Hibernate default mapping |
|
SERIAL Autoincrementing integer Range: 1 to 2147483647 Storage: 4 bytes |
|
|
SMALLINT Small-range integer Range: -32768 to +32767 Storage: 2 bytes |
Hibernate default mapping |
|
TEXT Character string with variable unlimited length. |
Hibernate default mapping |
|
TIME WITH TIME ZONE Time of day with time zone. Storage: 12 bytes Range: 00:00:00+1459 - 24:00:00-1459 Resolution: 1 microsecond / 14 digits |
Hibernate default mapping |
|
TIME WITH TIME ZONE Time of day without time zone. Storage: 8 bytes Range: 00:00:00 - 24:00:00 Resolution: 1 microsecond / 14 digits |
Hibernate default mapping |
|
TIMESTAMP WITH TIME ZONE Date and time with time zone. Storage: 8 bytes Range: 4713 BC - 294276 AD Resolution: 1 microsecond / 14 digits |
Hibernate default mapping |
|
TIMESTAMP WITHOUT TIME ZONE Date and time without time zone. Storage: 8 bytes Range: 4713 BC - 294276 AD Resolution: 1 microsecond / 14 digits |
Hibernate default mapping |
|