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(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com