not understand your requirements,
but here is PostgreSQL developer reference guide , go through it ,
let me know , if any questions.
https://www.enterprisedb.com/edb-docs/d/edb-postgres-advanced-server/user-guides/user-guide/11/toc.html
Quoting Naveen Kumar <naveenmcp@gmail.com>:
> can someone please help me on How to return multiple rows by stored
> procedure in postgresql? if possible with an example?
>
> Thank you
> Naveen