Top Description Fields Constructors Methods
org.jooq.util.postgres

public Class PostgresDataType

extends Object
Class Inheritance
Annotations
@Deprecated
forRemoval:true
since:3.11
Imports
java.math.BigDecimal, .BigInteger, java.sql.Date, .Time, .Timestamp, java.time.Instant, .OffsetDateTime, .OffsetTime, .Year, java.util.UUID, org.jooq.DataType, .JSON, .JSONB, .Record, .Result, .SQLDialect, org.jooq.impl.BuiltInDataType, .SQLDataType, org.jooq.types.DayToSecond, .UByte, .UInteger, .ULong, .UShort, .YearToMonth, .YearToSecond

Deprecated

for removal since 3.11.

- 3.11.0 - [#7375] - This type is part of jOOQ's internal API. Do not reference this type directly from client code. Referencing this type before the SQLDataType class has been initialised may lead to deadlocks! See https://github.com/jOOQ/jOOQ/issues/3777 for details.

Use the corresponding SQLDataType instead.

Supported data types for the SQLDialect#POSTGRES dialect
Author
Lukas Eder
See Also
http://www.postgresql.org/docs/9.0/interactive/datatype.html

Field Summary

Modifier and TypeField and Description
protected static final DataType<BigInteger>
__BIGINTEGER

protected static final DataType<ULong>
__BIGINTUNSIGNED

protected static final DataType<byte[]>
__BINARY

protected static final DataType<Boolean>
__BIT

protected static final DataType<UInteger>
__INTEGERUNSIGNED

protected static final DataType<String>
__LONGNVARCHAR

protected static final DataType<byte[]>
__LONGVARBINARY

protected static final DataType<String>
__LONGVARCHAR

protected static final DataType<String>
__NCHAR

protected static final DataType<String>
__NCLOB

protected static final DataType<String>
__NVARCHAR

protected static final DataType<UShort>
__SMALLINTUNSIGNED

protected static final DataType<Byte>
__TINYINT

protected static final DataType<UByte>
__TINYINTUNSIGNED

protected static final DataType<byte[]>
__VARBINARY

protected static final DataType<Year>
__YEAR

public static final DataType<String>
ACLITEM

public static final DataType<Object>
ANY

public static final DataType<Long>
BIGINT

public static final DataType<Long>
BIGSERIAL

public static final DataType<String>
BIT

public static final DataType<String>
BITVARYING

public static final DataType<Boolean>
BOOL

public static final DataType<Boolean>
BOOLEAN

public static final DataType<String>
BPCHAR

public static final DataType<byte[]>
BYTEA

public static final DataType<String>
CHAR

public static final DataType<String>
CHARACTER

public static final DataType<String>
CHARACTERVARYING

public static final DataType<Long>
CID

public static final DataType<Date>
DATE

public static final DataType<BigDecimal>
DECIMAL

public static final DataType<Double>
DOUBLEPRECISION

private static final SQLDialect
FAMILY

public static final DataType<Float>
FLOAT4

public static final DataType<Double>
FLOAT8

public static final DataType<Instant>
INSTANT

public static final DataType<Integer>
INT

public static final DataType<Short>
INT2

public static final DataType<Integer>
INT4

public static final DataType<Long>
INT8

public static final DataType<Integer>
INTEGER

public static final DataType<YearToSecond>
INTERVAL

public static final DataType<DayToSecond>
INTERVALDAYTOSECOND

public static final DataType<YearToMonth>
INTERVALYEARTOMONTH

public static final DataType<JSON>
JSON

public static final DataType<JSONB>
JSONB

public static final DataType<String>
NAME

public static final DataType<BigDecimal>
NUMERIC

public static final DataType<Long>
OID

public static final DataType<Long>
OIDVECTOR

public static final DataType<Float>
REAL

public static final DataType<Record>
RECORD

public static final DataType<Result<Record>>
REFCURSOR

public static final DataType<String>
REGPROC

public static final DataType<Integer>
SERIAL

public static final DataType<Short>
SERIAL2

public static final DataType<Integer>
SERIAL4

public static final DataType<Long>
SERIAL8

public static final DataType<Short>
SMALLINT

public static final DataType<Short>
SMALLSERIAL

public static final DataType<String>
TEXT

public static final DataType<Long>
TID

public static final DataType<Time>
TIME

public static final DataType<Timestamp>
TIMESTAMP

public static final DataType<OffsetDateTime>
TIMESTAMPTZ

public static final DataType<Timestamp>
TIMESTAMPWITHOUTTIMEZONE

public static final DataType<OffsetDateTime>
TIMESTAMPWITHTIMEZONE

public static final DataType<OffsetTime>
TIMETZ

public static final DataType<Time>
TIMEWITHOUTTIMEZONE

public static final DataType<OffsetTime>
TIMEWITHTIMEZONE

public static final DataType<UUID>
UUID

public static final DataType<String>
VARBIT

public static final DataType<String>
VARCHAR

public static final DataType<Object>
VOID

public static final DataType<Long>
XID

Constructor Summary

AccessConstructor and Description
public
PostgresDataType()

Method Summary

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait

Field Detail

__BIGINTEGERback to summary
protected static final DataType<BigInteger> __BIGINTEGER
__BIGINTUNSIGNEDback to summary
protected static final DataType<ULong> __BIGINTUNSIGNED
__BINARYback to summary
protected static final DataType<byte[]> __BINARY
__BITback to summary
protected static final DataType<Boolean> __BIT
__INTEGERUNSIGNEDback to summary
protected static final DataType<UInteger> __INTEGERUNSIGNED
__LONGNVARCHARback to summary
protected static final DataType<String> __LONGNVARCHAR
__LONGVARBINARYback to summary
protected static final DataType<byte[]> __LONGVARBINARY
__LONGVARCHARback to summary
protected static final DataType<String> __LONGVARCHAR
__NCHARback to summary
protected static final DataType<String> __NCHAR
__NCLOBback to summary
protected static final DataType<String> __NCLOB
__NVARCHARback to summary
protected static final DataType<String> __NVARCHAR
__SMALLINTUNSIGNEDback to summary
protected static final DataType<UShort> __SMALLINTUNSIGNED
__TINYINTback to summary
protected static final DataType<Byte> __TINYINT
__TINYINTUNSIGNEDback to summary
protected static final DataType<UByte> __TINYINTUNSIGNED
__VARBINARYback to summary
protected static final DataType<byte[]> __VARBINARY
__YEARback to summary
protected static final DataType<Year> __YEAR
ACLITEMback to summary
public static final DataType<String> ACLITEM
ANYback to summary
public static final DataType<Object> ANY
BIGINTback to summary
public static final DataType<Long> BIGINT
BIGSERIALback to summary
public static final DataType<Long> BIGSERIAL
BITback to summary
public static final DataType<String> BIT
BITVARYINGback to summary
public static final DataType<String> BITVARYING
BOOLback to summary
public static final DataType<Boolean> BOOL
BOOLEANback to summary
public static final DataType<Boolean> BOOLEAN
BPCHARback to summary
public static final DataType<String> BPCHAR
BYTEAback to summary
public static final DataType<byte[]> BYTEA
CHARback to summary
public static final DataType<String> CHAR
CHARACTERback to summary
public static final DataType<String> CHARACTER
CHARACTERVARYINGback to summary
public static final DataType<String> CHARACTERVARYING
CIDback to summary
public static final DataType<Long> CID
DATEback to summary
public static final DataType<Date> DATE
DECIMALback to summary
public static final DataType<BigDecimal> DECIMAL
DOUBLEPRECISIONback to summary
public static final DataType<Double> DOUBLEPRECISION
FAMILYback to summary
private static final SQLDialect FAMILY
FLOAT4back to summary
public static final DataType<Float> FLOAT4
FLOAT8back to summary
public static final DataType<Double> FLOAT8
INSTANTback to summary
public static final DataType<Instant> INSTANT
INTback to summary
public static final DataType<Integer> INT
INT2back to summary
public static final DataType<Short> INT2
INT4back to summary
public static final DataType<Integer> INT4
INT8back to summary
public static final DataType<Long> INT8
INTEGERback to summary
public static final DataType<Integer> INTEGER
INTERVALback to summary
public static final DataType<YearToSecond> INTERVAL
INTERVALDAYTOSECONDback to summary
public static final DataType<DayToSecond> INTERVALDAYTOSECOND
INTERVALYEARTOMONTHback to summary
public static final DataType<YearToMonth> INTERVALYEARTOMONTH
JSONback to summary
public static final DataType<JSON> JSON
JSONBback to summary
public static final DataType<JSONB> JSONB
NAMEback to summary
public static final DataType<String> NAME
NUMERICback to summary
public static final DataType<BigDecimal> NUMERIC
OIDback to summary
public static final DataType<Long> OID
OIDVECTORback to summary
public static final DataType<Long> OIDVECTOR
REALback to summary
public static final DataType<Float> REAL
RECORDback to summary
public static final DataType<Record> RECORD
REFCURSORback to summary
public static final DataType<Result<Record>> REFCURSOR
REGPROCback to summary
public static final DataType<String> REGPROC
SERIALback to summary
public static final DataType<Integer> SERIAL
SERIAL2back to summary
public static final DataType<Short> SERIAL2
SERIAL4back to summary
public static final DataType<Integer> SERIAL4
SERIAL8back to summary
public static final DataType<Long> SERIAL8
SMALLINTback to summary
public static final DataType<Short> SMALLINT
SMALLSERIALback to summary
public static final DataType<Short> SMALLSERIAL
TEXTback to summary
public static final DataType<String> TEXT
TIDback to summary
public static final DataType<Long> TID
TIMEback to summary
public static final DataType<Time> TIME
TIMESTAMPback to summary
public static final DataType<Timestamp> TIMESTAMP
TIMESTAMPTZback to summary
public static final DataType<OffsetDateTime> TIMESTAMPTZ
TIMESTAMPWITHOUTTIMEZONEback to summary
public static final DataType<Timestamp> TIMESTAMPWITHOUTTIMEZONE
TIMESTAMPWITHTIMEZONEback to summary
public static final DataType<OffsetDateTime> TIMESTAMPWITHTIMEZONE
TIMETZback to summary
public static final DataType<OffsetTime> TIMETZ
TIMEWITHOUTTIMEZONEback to summary
public static final DataType<Time> TIMEWITHOUTTIMEZONE
TIMEWITHTIMEZONEback to summary
public static final DataType<OffsetTime> TIMEWITHTIMEZONE
UUIDback to summary
public static final DataType<UUID> UUID
VARBITback to summary
public static final DataType<String> VARBIT
VARCHARback to summary
public static final DataType<String> VARCHAR
VOIDback to summary
public static final DataType<Object> VOID
XIDback to summary
public static final DataType<Long> XID

Constructor Detail

PostgresDataTypeback to summary
public PostgresDataType()