Run Postgres function that produces result set

已计划

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

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

0

请先登录再写评论。