Insert data to PostgreSQL tables with int array fields
Hello,
I try to experiment with Talend and for my purposes it is necessary to insert array (integer[]) data to PostgreSQL tables . Is it possible?
I use tPostgresqlOutput component.
I don't see corresponding type in list of DB types for integer[].
Source (Input) field type is List.
Error I've got:
org.postgresql.util.PSQLException:Can't infer the SQL type to use for an instance of java.util.ArrayList. Use setObject() with an explicit Types value to specify the type to use.
I tried to convert it to string and insert like string with same syntax ('{1,2,3}')', but there was error too.
Thanks for help.
