From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | "Muthukumar(dot)GK" <muthankumar(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Multiple result set not displayed in PgAdmin4 |
Date: | 2020-11-23 15:19:18 |
Message-ID: | b8adcc68-2486-e9df-2743-26302ab609e3@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2020-11-23 15:49:53 | Re: ERROR : invalid transaction termination : PostgreSQL v12 |
Previous Message | Jagmohan Kaintura | 2020-11-23 08:36:00 | ERROR : invalid transaction termination : PostgreSQL v12 |