Five Stars

PostgreSql update

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;'

  • Data Integration
Tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions
Five Stars

Re: PostgreSql update

postgresupdate.PNG

 

I checked these options .

now its working

2 REPLIES
Nine Stars TRF
Nine Stars

Re: PostgreSql update

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


TRF
Five Stars

Re: PostgreSql update

postgresupdate.PNG

 

I checked these options .

now its working