Arrays

PostgreSQL® provides robust support for array data types as column types, function arguments and criteria in where clauses. There are several ways to create arrays with pgJDBC.

The java.sql. Connection.createArrayOf(String, Object[]) can be used to create an java.sql. Array from Object[] instances (Note: this includes both primitive and object multi-dimensional arrays). A similar method org.postgresql.PGConnection.createArrayOf(String, Object) provides support for primitive array types. The java.sql.Array object returned from these methods can be used in other methods, such as PreparedStatement.setArray(int, Array) .

The following types of arrays support binary representation in requests and can be used in PreparedStatement.setObject