PostgreSQL
Data type | RapidClipse default mapping | Generated Javacode (example) | |
|---|---|---|---|
MONEY Currency amount Range: -92233720368547758.08 to +92233720368547758.07 Storage: 8 bytes | <sql-type jdbc-type="NUMERIC" name="money" hibernate-type="java.math.BigDecimal" />visitor.addPropertyColumnDefinitionFix(new PropertyColumnDefinitionFix(
new String[]{"MONEY"},new String[]{"java.math.BigDecimal"},"money")); | private BigDecimal moneyTest;@Column(name = "`MoneyTest`", scale = 0,
columnDefinition = "money")
public BigDecimal getMoneyTest() {
return this.moneyTest;
} | |
BIGINT Large-range integer Range: -9223372036854775808 to 9223372036854775807 Storage: 8 bytes | Hibernate default mapping | private Long bigintTest;@Column(name = "`BigintTest`")
public Long getBigintTest() {
return this.bigintTest;
} | |
BIGSERIAL Large autoincrementing integer 1 to 9223372036854775807 Storage: 8 bytes | Hibernate default mapping | private long bigserial;@Column(name = "`Bigserial`", nullable = false)
public long getBigserial() {
return this.bigserial;
} | |
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 | private Boolean booleanTest;@Column(name = "`BooleanTest`")
public Boolean getBooleanTest() {
return this.booleanTest;
} | |
BYTEA A variable-length binary string. Storage: 1 or 4 bytes plus the actual binary string. | Hibernate default mapping | private byte[] byteaTest;@Column(name = "`ByteaTest`")
public byte[] getByteaTest() {
return this.byteaTest;
} | |
CHARACTER Character string with fixed-length and blank padding. | visitor.addPropertyColumnDefinitionFix(new PropertyColumnDefinitionFix(
new String[]{"BPCHAR"},new String[]{"java.lang.String"},"bpchar")); | private String characterTest;@Column(name = "`CharacterTest`", length = 10,
columnDefinition = "bpchar")
public String getCharacterTest() {
return this.characterTest;
} | |
CHARACTER VARYING Character string with variable-length with limit. | Hibernate default mapping | private String characterVaryingTest;@Column(name = "`Character_varyingTest`")
public String getCharacterVaryingTest() {
return this.characterVaryingTest;
}
| |
DATE Storage: 4 bytes Range: 4713 BC - 5874897 AD Resolution: 1 day | Hibernate default mapping | private Date dateTest;@Temporal(TemporalType.DATE)
@Column(name = "`DateTest`", length = 13)
public Date getDateTest() {
return this.dateTest;
} | |
DOUBLE PRECISION A user-specified precision, exact number Range: 15 decimal digits precision Storage: 8 bytes | Hibernate default mapping | private Double doublePrecisionTest;@Column(name = "`Double_precisionTest`", precision = 17,
scale = 17)
public Double getDoublePrecisionTest() {
return this.doublePrecisionTest;
} | |
INTEGER A normal integer Range: -2147483648 to +2147483647 Storage: 4 bytes | Hibernate default mapping | private Integer integerTest;@Column(name = "`IntegerTest`")
public Integer getIntegerTest() {
return this.integerTest;
} | |
NUMERIC A user-specified precision, exact number Range: no limit Storage: variable | Hibernate default mapping | private BigDecimal numericTest;@Column(name = "`NumericTest`", precision = 131089,
scale = 0)
public BigDecimal getNumericTest() {
return this.numericTest;
} | |
REAL A user-specified precision, exact number Range: 6 decimal digits precision Storage: 4 bytes | Hibernate default mapping | private Float realTest;@Column(name = "`RealTest`", precision = 8,
scale = 8)
public Float getRealTest() {
return this.realTest;
} | |
SERIAL Autoincrementing integer Range: 1 to 2147483647 Storage: 4 bytes | visitor.addPropertyColumnDefinitionFix(new PropertyColumnDefinitionFix(
new String[]{"SERIAL"},new String[]{"java.lang.Integer","int"},"int2")); | private int serialTest;@Column(name = "`SerialTest`", nullable = false)
public int getSerialTest() {
return this.serialTest;
} | |
SMALLINT Small-range integer Range: -32768 to +32767 Storage: 2 bytes | Hibernate default mapping | private Short smallintTest;@Column(name = "`SmallintTest`")
public Short getSmallintTest() {
return this.smallintTest;
} | |
TEXT Character string with variable unlimited length. | Hibernate default mapping | private BigDecimal moneyTest;@Column(name = "`TextTest`")
public String getTextTest() {
return this.textTest;
} | |
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 | private Date timeWithTimeZoneTest;@Temporal(TemporalType.TIME)
@Column(name = "`Time_with_time_zoneTest`", length = 21)
public Date getTimeWithTimeZoneTest() {
return this.timeWithTimeZoneTest;
} | |
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 | private Date timeWithoutTimeZoneTest;@Temporal(TemporalType.TIME)
@Column(name = "`Time_without_time_zoneTest`", length = 15)
public Date getTimeWithoutTimeZoneTest() {
return this.timeWithoutTimeZoneTest;
} | |
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 | private Date timestampWithTimeZoneTest;@Temporal(TemporalType.TIMESTAMP)
@Column(name = "`Timestamp_with_time_zoneTest`", length = 35)
public Date getTimestampWithTimeZoneTest() {
return this.timestampWithTimeZoneTest;
} | |
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 | private Date timestampWithoutTimeZoneTest;@Temporal(TemporalType.TIMESTAMP)
@Column(name = "`Timestamp_without_time_zoneTest`", length = 29)
public Date getTimestampWithoutTimeZoneTest() {
return this.timestampWithoutTimeZoneTest;
} |
XDEV Software Corp. - One Embarcadero Center, San Francisco, CA 94111, US
Copyright © 2015. XDEV Software Corp. All rights reserved.