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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2016-07-11 06:40 AM

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)
Labels
200 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2016-07-18 05:22 AM
Author

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