Insert data to PostgreSQL tables with int array fields

One Star

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

Re: Insert data to PostgreSQL tables with int array fields

Hi,
Please see this related forum: Forum 28545, hope you will get a light from it.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.