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.

0
1 comment

There is an issue https://youtrack.jetbrains.com/issue/DBE-1734 . And we hope it'll be implemented soon.

0

Please sign in to leave a comment.