Thread: Enhancement Request - Query Tool - Run non-contiguous highlighted code

Enhancement Request - Query Tool - Run non-contiguous highlighted code

From
Christopher Maurer
Date:
PGADMIN4's Query Tool will run only the highlighted SQL when a section of the SQL window is highlighted.  In the Windows operating system, this same window allows the highlighting of non-contiguous areas using ctrl-click&drag on the mouse, but executing such multi-region highlighted code fails because only the bottom-most highlighted region is executed.

Note that this could be VERY useful when you have coded a CTE (common table expression), as this code is at the top of the SQL and its utilization may occur significantly below its definition.
Hi Christopher,

Can you please report this here - https://github.com/pgadmin-org/pgadmin4/issues/new? Additionally, please also add some screenshots or screen recording to help us understand the issue better.

On Sun, Mar 17, 2024 at 10:12 PM Christopher Maurer <chrismaurer52@gmail.com> wrote:
PGADMIN4's Query Tool will run only the highlighted SQL when a section of the SQL window is highlighted.  In the Windows operating system, this same window allows the highlighting of non-contiguous areas using ctrl-click&drag on the mouse, but executing such multi-region highlighted code fails because only the bottom-most highlighted region is executed.

Note that this could be VERY useful when you have coded a CTE (common table expression), as this code is at the top of the SQL and its utilization may occur significantly below its definition.


--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | enterprisedb.com
"Don't Complain about Heat, Plant a TREE"