Talend component to call/run PL/pgSQL script

[rgranado]

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]

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]

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 · Accepted solution]

Hi,

   Please refer the below Talend help document link for details.

https://help.talend.com/reader/hCrOzogIwKfuR3mPf~LydA/4slcLUIcm7Jl_vgEha1fPg

Warm Regards,

Nikhil Thampi