I am attempting to insert rows into a Postgres table that has a column defined as a character varying array. I am trying to use a tMap component but there does not seem to be a suitable data type to map to a column of this type. I have tried using a tJavaRow and built a java String[] and that didn't work either.
I have searched extensively and have found no information regarding this. Has anyone successfully done this before?
Thanks in advance,
T
hi,
try to add varchar[] in window -> preferences -> talend -> specific setting -> metadata of talend type
drom java type to db type & db type to java type for varchar [].(i've done it for json type for postgres without problem)
but still the way to propagate String[] type in Talend flow ... no idea right now !
regards
laurent