Re: Multiple result set not displayed in PgAdmin4

2020-11-23 Thread Joshua Drake
Howdy, I believe you would receive more help from the proper forum for PgAdmin4: https://www.pgadmin.org/support/list/ This is a list for PostgreSQL and it's software. PostgreSQL's client is psql which is a command line client. Thanks! JD >> >>

Re: Multiple result set not displayed in PgAdmin4

2020-11-23 Thread Muthukumar.GK
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. we are planning to migrate things from SQL to postgresql.. most of our existing SQL stored procedures will return multiple result sets. So we

Re: Multiple result set not displayed in PgAdmin4

2020-11-23 Thread Adrian Klaver
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 pr

Re: Multiple result set not displayed in PgAdmin4

2020-11-23 Thread Adrian Klaver
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

Multiple result set not displayed in PgAdmin4

2020-11-23 Thread Muthukumar.GK
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