Обсуждение: Multiple result set not displayed in PgAdmin4
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.
Regards
Muthukumar
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
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 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> 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
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
Howdy,
I believe you would receive more help from the proper forum for PgAdmin4:
This is a list for PostgreSQL and it's software. PostgreSQL's client is psql which is a command line client.
Thanks!
JD