https://community.qlik.com/t5/Talend-Studio/tELTPostgresOutput-and-Update-option/m-p/2322625#M92549 Hi, <BR />Here is&nbsp; <FONT face="Arial, Helvetica, sans-serif">grammar of update sql in postgresql:<A href="https://www.postgresql.org/docs/8.1/static/sql-update.html" target="_blank" rel="nofollow noopener noreferrer">https://www.postgresql.org/docs/8.1/static/sql-update.html</A></FONT> <BR />Best regards <BR />Sabrina Tue, 26 Jul 2016 09:21:57 GMT Anonymous 2016-07-26T09:21:57Z https://community.qlik.com/t5/Talend-Studio/tELTPostgresOutput-and-Update-option/m-p/2322624#M92548 Hi <BR />I am baffled what to write in "WHERE clauses" textbox to make Update happen. Is there a clear sample how to use it exactly - I try to write there sourcetablenamealias.primary_key=targetable.primary_key (like it is in ELTmap) but it wont resolve <BR />I have both source and target defined with the same primary key but ELT component does not seem to use them to update like ETL component does (when I leave "WHERE clauses" textbox empty I get an error that more than one match found for update so I assume i does not actually use it since my primary key is autogenerated unique sequence. <BR />Regards&nbsp; <BR />Kristjan Fri, 22 Jul 2016 12:13:50 GMT https://community.qlik.com/t5/Talend-Studio/tELTPostgresOutput-and-Update-option/m-p/2322624#M92548 Anonymous 2016-07-22T12:13:50Z https://community.qlik.com/t5/Talend-Studio/tELTPostgresOutput-and-Update-option/m-p/2322625#M92549 Hi, <BR />Here is&nbsp; <FONT face="Arial, Helvetica, sans-serif">grammar of update sql in postgresql:<A href="https://www.postgresql.org/docs/8.1/static/sql-update.html" target="_blank" rel="nofollow noopener noreferrer">https://www.postgresql.org/docs/8.1/static/sql-update.html</A></FONT> <BR />Best regards <BR />Sabrina Tue, 26 Jul 2016 09:21:57 GMT https://community.qlik.com/t5/Talend-Studio/tELTPostgresOutput-and-Update-option/m-p/2322625#M92549 Anonymous 2016-07-26T09:21:57Z