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 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.