topic Re: sql query on multiple tables in postgresql database in Talend Studio

sql query on multiple tables in postgresql database

sam9 — Wed, 30 Oct 2019 16:37:23 GMT

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.

Re: sql query on multiple tables in postgresql database

Anonymous — Thu, 31 Oct 2019 03:32:55 GMT

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

Re: sql query on multiple tables in postgresql database

TRF — Thu, 31 Oct 2019 11:03:29 GMT

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.

Re: sql query on multiple tables in postgresql database

sam9 — Tue, 05 Nov 2019 14:51:10 GMT

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