One Star

Error: bulk insert into Postgresql tPostgresqlBulkExec_1

Hi,
i am trying to bulk insert in postgresql and i am facing the error below:
Exception in component tPostgresqlBulkExec_1
org.postgresql.util.PSQLException: ERROR: COPY escape must be a single one-byte character

In my component, i have set delimiter to ";" , escape caracter to "\\" and enclosing caracter to "\"".
I also have tested with "standard_confirming_string" activated/dactivated but same error.
What could be the reason of this error ?
Best Regards
1 REPLY
Moderator

Re: Error: bulk insert into Postgresql tPostgresqlBulkExec_1

Hi,
Could you please take a look at a related jira issue:https://jira.talendforge.org/browse/TDI-22604?
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.