How to return a resultset from PostgreSQL stored procedure?

Question

Could anyone able to help me how to return a resultset from postgres sql stored procedure?

Possible duplicate of Postgresql stored procedure return select result set — technogeek1995
– technogeek1995, Commented Sep 24, 2019 at 16:52

Laurenz Albe · Accepted Answer · 2019-09-24 15:42:58Z

0

Simple:

CALL procedure_name(arg1, arg2);

will return a result set if the procedure has INOUT parameters.

answered Sep 24, 2019 at 15:42

Laurenz Albe

257k22 gold badges314 silver badges390 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1