topic Re: Talend component to call/run PL/pgSQL script in Talend Studio

Talend component to call/run PL/pgSQL script

rgranado — Wed, 21 Nov 2018 17:54:47 GMT

Hi,

What component should I use to execute a Postgres function? I need to call this script after the execution plan is completed.

thanks

Rhoda

Anonymous — Wed, 21 Nov 2018 18:27:19 GMT

Hi,

Could you please try tPostgreSQLRow component for our requirement?

If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

rgranado — Wed, 21 Nov 2018 18:34:40 GMT

Do you have an example?

The example script I have is this but I have more complicated one that uses a loop to execute a Grant command.

"GRANT SELECT ON ALL TABLES IN SCHEMA test TO public"

Anonymous — Wed, 21 Nov 2018 18:37:13 GMT

Hi,

Please refer the below Talend help document link for details.

Warm Regards,

Nikhil Thampi