Re: Multiple result set not displayed in PgAdmin4

On 11/23/20 8:07 AM, Muthukumar.GK wrote:
> Hi Adrian,
> 
> If PG admin 4 return only last result set then,  how can we call the  
> procedure/function to get the multiple result set from dot net application.

pgAdmin4 != Postgres, it is just a GUI client and in this case has a 
limitation.

Run the procedure in the command line client psql and you will see the 
results. I'm sure you will be able to get what you want in your .Net 
application.

> 
> we are planning to migrate things from SQL to postgresql.. most of our 
> existing SQL stored procedures will return multiple result sets. So we 
> need to achieve Same multiple result set in postgreSql.. Kindly advise me..
> 
> Regards
> Muthukumar.GK
> 
> On Mon, Nov 23, 2020, 8:49 PM Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>> wrote:
> 
>     On 11/22/20 8:53 PM, Muthukumar.GK wrote:
>      > Hi Team,
>      >
>      > I have created function in postgre sql 13 which  will return two
>     result.
>      > But when execute i can able to see the last cursor (query result
>     set of
>      > last select )result set  in Data output window of Pgadmin4. i tried
>      > executing the  cursor inside the transaction as well
>     (BEING.....COMMIT).
>      > but i still do not see both result set one by one (likeSQL) in data
>      > output window. Please let me know if there is any limitation in
>     pgadmin4
>      > tool that multiple result set will not be displayed in Data
>     output Window.
> 
>       From what I remember pgAdmin4 will only display the last result.
> 
>      >
>      > Regards
>      > Muthukumar
> 
> 
>     -- 
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com