Run postgresql stored procedure

[Anonymous]

Hi guys!
Could you please help me to figure out if it's possible or not to run a postgresql stored procedure within a Talend Job? And if yes I'll be very grateful for an example.
Thank you a lot in advance!!!

[Anonymous]

Hi,

if it's possible or not to create stored procedure within a Talend Job?

Do you want to call your stored procedure in talend job? tMysqlSP?
Could you please stick to one topic: https://community.talend.com/t5/Design-and-Development/creating-procedure-in-mysql/td-p/66532 so that we can pay individual attention to it.
Best regards
Sabrina

[Anonymous]

Hi,

how do you call stored procedure inside the mentioned component tPostgresqlRow?

[Anonymous]

Hello,

You can use tPostgresqlRow for call any SQL code, do it same as PostgreSQL console - plain SQL code.

Best regards

Sabrina