Module org.jooq

Package org.jooq.util.postgres

Class PostgresUtils

java.lang.Object

org.jooq.util.postgres.PostgresUtils

public class PostgresUtils
extends Object

A collection of utilities to cover the Postgres JDBC driver's missing implementations.

The Postgres JDBC driver is known to miss out on quite a few JDBC feature implementations. This class should fill those gaps.

Author:

Lukas Eder, Peter Ertl

Constructor Summary

Constructors

Constructor	Description
PostgresUtils()

Method Summary

Modifier and Type	Method	Description
static byte[]	toBytes(String string)	Parse a Postgres-encoded bytea string
static DayToSecond	toDayToSecond(Object pgInterval)	Convert a Postgres interval to a jOOQ DAY TO SECOND interval
static List<String>	toPGArray(String input)	Tokenize a PGObject input string.
static String	toPGArrayString(Object[] value)	Create a Postgres string representation of an array
static Object	toPGInterval(DayToSecond interval)	Convert a jOOQ DAY TO SECOND interval to a Postgres representation
static Object	toPGInterval(YearToMonth interval)	Convert a jOOQ YEAR TO MONTH interval to a Postgres representation
static Object	toPGInterval(YearToSecond interval)	Convert a jOOQ YEAR TO SECOND interval to a Postgres representation
static List<String>	toPGObject(String input)	Tokenize a PGObject input string.
static String	toPGString(byte[] binary)	Create a PostgreSQL string representation of a binary.
static String	toPGString(Object o)	Create a PostgreSQL string representation of any object.
static String	toPGString(Record r)	Create a PostgreSQL string representation of a record.
static Object	toRedshiftInterval(DayToSecond interval)	Convert a jOOQ DAY TO SECOND interval to a Redshift representation
static Object	toRedshiftInterval(YearToMonth interval)	Convert a jOOQ YEAR TO MONTH interval to a Redshift representation
static Object	toRedshiftInterval(YearToSecond interval)	Convert a jOOQ YEAR TO SECOND interval to a Redshift representation
static YearToMonth	toYearToMonth(Object pgInterval)	Convert a Postgres interval to a jOOQ YEAR TO MONTH interval
static YearToSecond	toYearToSecond(Object pgInterval)	Convert a Postgres interval to a jOOQ YEAR TO SECOND interval

Methods inherited from class java.lang.Object

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

Constructor Details

PostgresUtils

public PostgresUtils()

Method Details

toBytes

public static byte[] toBytes(String string)

Parse a Postgres-encoded bytea string

toPGInterval

public static Object toPGInterval(DayToSecond interval)

Convert a jOOQ DAY TO SECOND interval to a Postgres representation

toPGInterval

public static Object toPGInterval(YearToSecond interval)

Convert a jOOQ YEAR TO SECOND interval to a Postgres representation

toPGInterval

public static Object toPGInterval(YearToMonth interval)

Convert a jOOQ YEAR TO MONTH interval to a Postgres representation

toRedshiftInterval

@Pro
public static Object toRedshiftInterval(DayToSecond interval)

Convert a jOOQ DAY TO SECOND interval to a Redshift representation

toRedshiftInterval

@Pro
public static Object toRedshiftInterval(YearToSecond interval)

Convert a jOOQ YEAR TO SECOND interval to a Redshift representation

toRedshiftInterval

@Pro
public static Object toRedshiftInterval(YearToMonth interval)

Convert a jOOQ YEAR TO MONTH interval to a Redshift representation

toDayToSecond

public static DayToSecond toDayToSecond(Object pgInterval)

Convert a Postgres interval to a jOOQ DAY TO SECOND interval

toYearToMonth

public static YearToMonth toYearToMonth(Object pgInterval)

Convert a Postgres interval to a jOOQ YEAR TO MONTH interval

toYearToSecond

public static YearToSecond toYearToSecond(Object pgInterval)

Convert a Postgres interval to a jOOQ YEAR TO SECOND interval

toPGArray

public static List<String> toPGArray(String input)

Tokenize a PGObject input string.

toPGObject

public static List<String> toPGObject(String input)

Tokenize a PGObject input string.

toPGArrayString

public static String toPGArrayString(Object[] value)

Create a Postgres string representation of an array

toPGString

public static String toPGString(Object o)

Create a PostgreSQL string representation of any object.

toPGString

public static String toPGString(Record r)

Create a PostgreSQL string representation of a record.

toPGString

public static String toPGString(byte[] binary)

Create a PostgreSQL string representation of a binary.