PostgreSql update

[Anonymous]

Hi All

how to write 'where' query in PostgreSQL output component  

the query is 'update table_name set table2.enc_id=table1.enc_id where table1.filename =table2.filename & table1.practice=table2.practice;'

[TRF]

If you want to write plain SQL queries, use tPostgresqlRow component instead of tPostgresqlOutput

[Anonymous · Accepted solution]

I checked these options .

now its working