Unfortunatelyn there is no component for postgres like "tMySqlSP" (Stored Procedure).
But you can call your procedure via a "tPostgresqlRow".
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
So far, there is no official tPostgresqlSP component in Talend. Feel free to create a new feature on talend bug tracker.
You can use tPostgresqlRow for call any SQL code, do it same as PostgreSQL console - plain SQL code.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.