I'm attempting to write data from the .csv file to my postgreSQL database. The bond is okay, however when I run my job i recieve the next error:

Exception in component tPostgresqlOutput_1
org.postgresql.util.PSQLException: ERROR: zero-length delimited identifier at or near """"
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:328)
    at talend_test.exporttoexcel_0_1.exportToExcel.tFileInputDelimited_1Process(exportToExcel.java:568)
    at talend_test.exporttoexcel_0_1.exportToExcel.runJobInTOS(exportToExcel.java:1015)
    at talend_test.exporttoexcel_0_1.exportToExcel.main(exportToExcel.java:886)

My job really is easy: tFileInputDelimiter -> PostgreSQL_Output

I believe the error implies that the double quotes ought to be single quotes ("" -> ''), but how do i edit this in Talend?

Or perhaps is it one more reason? Can anybody assist me to on that one?


might be if u use customer.csv from repository then u need to change some property of customer file from metadata->file delimited->customer. u get edit existing file window for the reason that at step three (chk out step number at surface of window). for the reason that if u have ur file extension .csv then in Escape char configurations u have check up on csv option n escape char is """ and text enclosure can also be """ making some arrangement in file configurations that encoding is utf-8. n refresh your schema. your file appears like table format. then u can run jobs. its work.

and when your file isn't in repository then click element of ur file n do all above arrangement in fundamental configurations.