topic Re: Execute postgress function from Talend in Talend Studio

Execute postgress function from Talend

Anonymous — Sat, 16 Nov 2024 08:56:32 GMT

Do we have component to call postgress function?

Théo_Cap — Tue, 19 Dec 2017 09:01:12 GMT

Hello,

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.

Anonymous — Wed, 20 Dec 2017 07:22:31 GMT

Hello,

So far, there is no official tPostgresqlSP component in Talend. Feel free to create a new feature on talend bug tracker.

Best regards

Sabrina

Anonymous — Wed, 27 Jun 2018 15:22:16 GMT

Hi,

in which way I call the procedure inside tPostgresqlRow?

Anonymous — Thu, 05 Jul 2018 09:40:55 GMT

Hello,

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

Best regards

Sabrina