Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hi,
Could you please take a look at a related jira issue: https://jira.talendforge.org/browse/TDI-22604?
Best regards
Sabrina