Run Postgres function that produces result set
Planned
Given a function definition something like this:
CREATE FUNCTION getrefcursor (rc OUT refcursor)
RETURNS refcursor
AS $$
BEGIN
OPEN rc
FOR SELECT * FROM <some_table>
END;
$$ LANGUAGE plpgsql;
How should this function be called from a console? And how should the call be set up so that we can see the result set produced by the function?
Thank you.
Please sign in to leave a comment.
There is an issue https://youtrack.jetbrains.com/issue/DBE-1734 . And we hope it'll be implemented soon.