sql query on multiple tables in postgresql database

[sam9]

How and where can we write sql queries for tables in PostgreSQL?  I have a complex query which needs a lot of tables from Postgresql. I established a connection for the database.

[Anonymous]

Hello,

Please take a look at this component tPostgresqlRow which executes the SQL query stated onto database.

Here is online component reference about:

https://help.talend.com/reader/YxpC8~71OVAWmBgQIAFNtQ/8~S3D0fUc~paDFya2L0oVw 

Best regards

Sabrina

[TRF]

I suggest you to create and test a view on PostgreSQL side with the corresponding query, then use this view as a "simple" table in your tPostgresqlInput component with the desired where clause if needed.

[sam9]

I used the views but I want it without using the views. And I want the output as a csv file.