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

Additionally, the following types of arrays can be used in PreparedStatement.setObject methods and will use the defined type mapping:

Java Type Default PostgreSQL Type
short[] int2[]
int[] int4[]
long[] int8[]
float[] float4[]
double[] float8[]
boolean[] bool[]
String[] varchar[]