Run two select statements at the same time

[Emil760]

I would like to run 2 select statements at the same time

I want to run 2 or more select statments at the same time and see my result in separate windows for both tables

[casparsch]

Hi @Emil760 Not sure what you exactly want but maybe following is what you are looking for ...

• Open from pgAdmin the menu File -> preferences
• Within "Browser" select "Tab settings"
• In the field: "Open in new browser tab" select: "Query Tool" ^{Whilst writing this I'm not sure if you have to restart pgAdmin. I don't expect it.}
• Next time any query-tool wil open in a new window
• If you open 2 (or more) you can paste a query in the opened query-tool-window and execute them, in parallel

Regards and hope this helps.

[efendioglukdz]

Hi @casparsch , your advice is not the same behavior like I wanted in my feature request, that is closed due to dublicate request. Your advice to open always a new window for new statement seperates the results in different windows which is hard to compare visually.. Look at following image in SQL Server. When u enter 3 statements in SQL Server Studio u get 3 tableview results which can be very practical when u compare things.

[console2success]

not worked

[waynesbrain]

Thanks for working on this, pgAdmin 4 is great! @akshay-joshi

[adityatoshniwal]

Based on the discussion - https://github.com/psycopg/psycopg/discussions/1170 I've created a PR https://github.com/psycopg/psycopg/pull/1177 which will help in further implementation.