removing double quotes from columns while integrating oracle source object into postgresql using tOracleOutput

[Anonymous]

am currently using talend studio community version(7.1) to create replica objects on a postgresql database from an oracle source database using  tOracleOutput,the objects that are created on the postgresql database are having columns with double quotes.

How do i remove this double quotes before the objects are created on the postgresql.Please am new to talend and I have tried several stuffs i have found on the internet and none seems to be working or probably i dont know how to use them correctly.

[Anonymous]

Hi,

    Could you please share the overall job flow and problematic component's basic, advanced and schema screenshots for reference?

     Could you please advise how you are trying to create the table in PostgreSQL?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

firstly,it is tPostgresqlOutput that am using and not tOracleOutput.

The tables are created on the postgresql db but the columns are having double quotes and case sensitive which is not what i want,if i create a table on the postgresql db without using talend,the double quotes are not there.

i have attached the work flow here,both the input as well as the tPostgresqlOutput.

please any advice will be really appreciated.

Talend issues.docx

[Anonymous]

Hi,

   There is a similar issue in Talend community and its in resolved status.

   Could you please verify whether it helped you and update back?

https://community.talend.com/t5/Design-and-Development/resolved-Remove-double-quotes-while-creating-...

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

thanks for your prompt response,I do not have control over the source data,so this will not work for me

[Anonymous]

is there any component within the tPostgressql components that i can twik so as to remove the double quotes while creating the tables?

[Anonymous]

is there any component within the tPostgressqlOutput components that i can twik so as to remove the double quotes while creating the tables?

[Anonymous]

Hi,

     It is telling to change the column names to lower case and not source data.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

You mean changing the column names on the source DB to lower case?

i do not have the access to do that.

I have tried creating the table on the postgressql db with lower case and used the talend studio to insert into it instead of creating the table using talend but it gave me the error below while inserting into it

 ERROR: column "BRA_CODE" of relation "tmp_account_test" does not exist
Position: 39 Call getNextException to see other errors in the batch.
caused by: ERROR: column "BRA_CODE" of relation "tmp_account_test" does not exist
Position: 39

[Anonymous · Accepted solution]

Hi,

    Since you are using Create table option in tDBOutput, you should be having access to change the column names to lower case. The only change you need to do is to make sure that all the columns in your schema of tDBOutput are in lower case.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂