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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tPostgresqlOutput - Name of Columns with double quotes

Good afternoon , sorry if my English is not very good.
But I'm with trouble .
I am using a tOracleOutput for tPostgresqlOutput , when generating the command to insert the speakers are receiving double quotes. This generates an error allowing not perform insert.
Adjusting this case?

JAVA CODE (Column database example => COD_EMP, COD_UNIDADE_LOCAL)

String insert_tPostgresqlOutput_1 = "INSERT INTO \""
+ tableName_tPostgresqlOutput_1
+ "\" (\"COD_EMP\",\"COD_UNIDADE_LOCAL\",



COMMAND GENERATE:

INSERT INTO "table" ("COD_EMP","COD_UNIDADE_LOCAL"



Could someone show me how to adjust ?


Edit:
Version: 6.1.1

Labels (2)
1 Reply
Anonymous
Not applicable
Author

I managed to include the data.
In schema editing screen, I changed all the column names to lowercase.

I do not know if the right is without the double quotes, or if the correct lowercase.

Is there a way to do this automatically?