<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic tPostgresqlOutput - Name of Columns with double quotes in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/tPostgresqlOutput-Name-of-Columns-with-double-quotes/m-p/2371072#M134050</link>
    <description>&lt;P&gt;Good afternoon , sorry if my English is not very good.&lt;BR /&gt;But I'm with trouble .&lt;BR /&gt;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.&lt;BR /&gt;Adjusting this case?&lt;BR /&gt;&lt;BR /&gt;JAVA CODE (Column database example =&amp;gt; COD_EMP, COD_UNIDADE_LOCAL)&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt; 
&lt;PRE&gt;String insert_tPostgresqlOutput_1 = "INSERT INTO \""&lt;BR /&gt;						+ tableName_tPostgresqlOutput_1&lt;BR /&gt;						+ "\" (\"COD_EMP\",\"COD_UNIDADE_LOCAL\",&lt;/PRE&gt; 
&lt;P&gt;&lt;BR /&gt;&lt;BR /&gt;COMMAND GENERATE:&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt; 
&lt;PRE&gt;INSERT INTO "table" ("COD_EMP","COD_UNIDADE_LOCAL"&lt;/PRE&gt; 
&lt;P&gt;&lt;BR /&gt;&lt;BR /&gt;Could someone show me how to adjust ?&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;Edit:&lt;BR /&gt;Version: 6.1.1&lt;/P&gt;</description>
    <pubDate>Thu, 12 May 2016 21:02:21 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2016-05-12T21:02:21Z</dc:date>
    <item>
      <title>tPostgresqlOutput - Name of Columns with double quotes</title>
      <link>https://community.qlik.com/t5/Talend-Studio/tPostgresqlOutput-Name-of-Columns-with-double-quotes/m-p/2371072#M134050</link>
      <description>&lt;P&gt;Good afternoon , sorry if my English is not very good.&lt;BR /&gt;But I'm with trouble .&lt;BR /&gt;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.&lt;BR /&gt;Adjusting this case?&lt;BR /&gt;&lt;BR /&gt;JAVA CODE (Column database example =&amp;gt; COD_EMP, COD_UNIDADE_LOCAL)&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt; 
&lt;PRE&gt;String insert_tPostgresqlOutput_1 = "INSERT INTO \""&lt;BR /&gt;						+ tableName_tPostgresqlOutput_1&lt;BR /&gt;						+ "\" (\"COD_EMP\",\"COD_UNIDADE_LOCAL\",&lt;/PRE&gt; 
&lt;P&gt;&lt;BR /&gt;&lt;BR /&gt;COMMAND GENERATE:&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt; 
&lt;PRE&gt;INSERT INTO "table" ("COD_EMP","COD_UNIDADE_LOCAL"&lt;/PRE&gt; 
&lt;P&gt;&lt;BR /&gt;&lt;BR /&gt;Could someone show me how to adjust ?&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;Edit:&lt;BR /&gt;Version: 6.1.1&lt;/P&gt;</description>
      <pubDate>Thu, 12 May 2016 21:02:21 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/tPostgresqlOutput-Name-of-Columns-with-double-quotes/m-p/2371072#M134050</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2016-05-12T21:02:21Z</dc:date>
    </item>
    <item>
      <title>Re: tPostgresqlOutput - Name of Columns with double quotes</title>
      <link>https://community.qlik.com/t5/Talend-Studio/tPostgresqlOutput-Name-of-Columns-with-double-quotes/m-p/2371073#M134051</link>
      <description>I managed to include the data.&lt;BR /&gt;In schema editing screen, I changed all the column names to lowercase.&lt;BR /&gt;&lt;BR /&gt;I do not know if the right is without the double quotes, or if the correct lowercase.&lt;BR /&gt;&lt;BR /&gt;Is there a way to do this automatically?</description>
      <pubDate>Thu, 12 May 2016 22:02:47 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/tPostgresqlOutput-Name-of-Columns-with-double-quotes/m-p/2371073#M134051</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2016-05-12T22:02:47Z</dc:date>
    </item>
  </channel>
</rss>

