Working with Stored Procedures in Postgres Data Source

When working with Postgres data source, it’s important to understand how to make stored procedures appear and how to call them.

Procedures

Procedures in Postgres do not return any data. To call a procedure, you can use the following syntax: CALL procedurename().

For example, if you want to update the freight data for a name ‘Test’, you would use the following steps:

Functions

Functions in Postgres can return data. To get the result of a function, you can use the following syntax: Select * from function().

For example, to get the result of a function, you would use the following step: