org.jooq.util.postgres

Class PostgresDataType

java.lang.Object

org.jooq.util.postgres.PostgresDataType

public class PostgresDataType
extends Object

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

Fields

Modifier and Type	Field and Description
protected static DataType<BigInteger>	__BIGINTEGER
protected static DataType<ULong>	__BIGINTUNSIGNED
protected static DataType<byte[]>	__BINARY
protected static DataType<Boolean>	__BIT
protected static DataType<UInteger>	__INTEGERUNSIGNED
protected static DataType<String>	__LONGNVARCHAR
protected static DataType<byte[]>	__LONGVARBINARY
protected static DataType<String>	__LONGVARCHAR
protected static DataType<String>	__NCHAR
protected static DataType<String>	__NCLOB
protected static DataType<String>	__NVARCHAR
protected static DataType<UShort>	__SMALLINTUNSIGNED
protected static DataType<Byte>	__TINYINT
protected static DataType<UByte>	__TINYINTUNSIGNED
protected static DataType<byte[]>	__VARBINARY
static DataType<String>	ACLITEM
static DataType<Object>	ANY
static DataType<Long>	BIGINT
static DataType<Long>	BIGSERIAL
static DataType<String>	BIT
static DataType<String>	BITVARYING
static DataType<Boolean>	BOOL
static DataType<Boolean>	BOOLEAN
static DataType<String>	BPCHAR
static DataType<byte[]>	BYTEA
static DataType<String>	CHAR
static DataType<String>	CHARACTER
static DataType<String>	CHARACTERVARYING
static DataType<Long>	CID
static DataType<Date>	DATE
static DataType<BigDecimal>	DECIMAL
static DataType<Double>	DOUBLEPRECISION
static DataType<Float>	FLOAT4
static DataType<Double>	FLOAT8
static DataType<Integer>	INT
static DataType<Short>	INT2
static DataType<Integer>	INT4
static DataType<Long>	INT8
static DataType<Integer>	INTEGER
static DataType<DayToSecond>	INTERVALDAYTOSECOND
static DataType<YearToMonth>	INTERVALYEARTOMONTH
static DataType<Object>	JSON
static DataType<BigDecimal>	MONEY
static DataType<String>	NAME
static DataType<BigDecimal>	NUMERIC
static DataType<Long>	OID
static DataType<Long>	OIDVECTOR
static DataType<Float>	REAL
static DataType<Result<Record>>	REFCURSOR
static DataType<String>	REGPROC
static DataType<Integer>	SERIAL
static DataType<Integer>	SERIAL4
static DataType<Long>	SERIAL8
static DataType<Short>	SMALLINT
static DataType<String>	TEXT
static DataType<Long>	TID
static DataType<Time>	TIME
static DataType<Timestamp>	TIMESTAMP
static DataType<Timestamp>	TIMESTAMPTZ
static DataType<Timestamp>	TIMESTAMPWITHOUTTIMEZONE
static DataType<Timestamp>	TIMESTAMPWITHTIMEZONE
static DataType<Time>	TIMETZ
static DataType<Time>	TIMEWITHOUTTIMEZONE
static DataType<Time>	TIMEWITHTIMEZONE
static DataType<UUID>	UUID
static DataType<String>	VARBIT
static DataType<String>	VARCHAR
static DataType<Object>	VOID
static DataType<Long>	XID

Constructor Summary

Constructors

Constructor and Description
PostgresDataType()

Method Summary

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

SMALLINT

public static final DataType<Short> SMALLINT

INT2

public static final DataType<Short> INT2

INT

public static final DataType<Integer> INT

INTEGER

public static final DataType<Integer> INTEGER

INT4

public static final DataType<Integer> INT4

BIGINT

public static final DataType<Long> BIGINT

INT8

public static final DataType<Long> INT8

DOUBLEPRECISION

public static final DataType<Double> DOUBLEPRECISION

FLOAT8

public static final DataType<Double> FLOAT8

REAL

public static final DataType<Float> REAL

FLOAT4

public static final DataType<Float> FLOAT4

BOOLEAN

public static final DataType<Boolean> BOOLEAN

BOOL

public static final DataType<Boolean> BOOL

NUMERIC

public static final DataType<BigDecimal> NUMERIC

DECIMAL

public static final DataType<BigDecimal> DECIMAL

VARCHAR

public static final DataType<String> VARCHAR

CHARACTERVARYING

public static final DataType<String> CHARACTERVARYING

CHAR

public static final DataType<String> CHAR

CHARACTER

public static final DataType<String> CHARACTER

TEXT

public static final DataType<String> TEXT

DATE

public static final DataType<Date> DATE

TIME

public static final DataType<Time> TIME

TIMESTAMP

public static final DataType<Timestamp> TIMESTAMP

BYTEA

public static final DataType<byte[]> BYTEA

INTERVALYEARTOMONTH

public static final DataType<YearToMonth> INTERVALYEARTOMONTH

INTERVALDAYTOSECOND

public static final DataType<DayToSecond> INTERVALDAYTOSECOND

__BINARY

protected static final DataType<byte[]> __BINARY

__BIT

protected static final DataType<Boolean> __BIT

__LONGVARBINARY

protected static final DataType<byte[]> __LONGVARBINARY

__LONGVARCHAR

protected static final DataType<String> __LONGVARCHAR

__NCHAR

protected static final DataType<String> __NCHAR

__NCLOB

protected static final DataType<String> __NCLOB

__LONGNVARCHAR

protected static final DataType<String> __LONGNVARCHAR

__NVARCHAR

protected static final DataType<String> __NVARCHAR

__TINYINT

protected static final DataType<Byte> __TINYINT

__VARBINARY

protected static final DataType<byte[]> __VARBINARY

__TINYINTUNSIGNED

protected static final DataType<UByte> __TINYINTUNSIGNED

__SMALLINTUNSIGNED

protected static final DataType<UShort> __SMALLINTUNSIGNED

__INTEGERUNSIGNED

protected static final DataType<UInteger> __INTEGERUNSIGNED

__BIGINTUNSIGNED

protected static final DataType<ULong> __BIGINTUNSIGNED

__BIGINTEGER

protected static final DataType<BigInteger> __BIGINTEGER

SERIAL

public static final DataType<Integer> SERIAL

SERIAL4

public static final DataType<Integer> SERIAL4

BIGSERIAL

public static final DataType<Long> BIGSERIAL

SERIAL8

public static final DataType<Long> SERIAL8

MONEY

public static final DataType<BigDecimal> MONEY

BITVARYING

public static final DataType<String> BITVARYING

VARBIT

public static final DataType<String> VARBIT

BIT

public static final DataType<String> BIT

BPCHAR

public static final DataType<String> BPCHAR

TIMEWITHOUTTIMEZONE

public static final DataType<Time> TIMEWITHOUTTIMEZONE

TIMEWITHTIMEZONE

public static final DataType<Time> TIMEWITHTIMEZONE

TIMETZ

public static final DataType<Time> TIMETZ

TIMESTAMPWITHOUTTIMEZONE

public static final DataType<Timestamp> TIMESTAMPWITHOUTTIMEZONE

TIMESTAMPWITHTIMEZONE

public static final DataType<Timestamp> TIMESTAMPWITHTIMEZONE

TIMESTAMPTZ

public static final DataType<Timestamp> TIMESTAMPTZ

REFCURSOR

public static final DataType<Result<Record>> REFCURSOR

ANY

public static final DataType<Object> ANY

UUID

public static final DataType<UUID> UUID

JSON

public static final DataType<Object> JSON

OID

public static final DataType<Long> OID

OIDVECTOR

public static final DataType<Long> OIDVECTOR

XID

public static final DataType<Long> XID

TID

public static final DataType<Long> TID

CID

public static final DataType<Long> CID

ACLITEM

public static final DataType<String> ACLITEM

NAME

public static final DataType<String> NAME

REGPROC

public static final DataType<String> REGPROC

VOID

public static final DataType<Object> VOID

Constructor Detail

PostgresDataType

public PostgresDataType()