Can I have two different Query Editor panels in PGAdmin, side by side?
If not, is there another way of avoiding the pain point that's making me want two panels? That is:
When I'm building up a complex query, there's so much back-and forth that using the Scratch panel to swap queries gets cumbersome. It's like:
- Start with a basic query.
- Test run it.
- Add a where clause
- Cut-paste the query to the scratch panel
- Run a little SELECT to find a valid value to test the new where clause with.
- Move the query back from the scratch panel, plug in the testing value, retest.
- Add a JOIN clause, retest
- Add a WHERE clause using the new join
- Again copy the query over to the scratch panel
- Run another little select line to find a valid value to plug into the WHERE for testing.
- Copy the query back from the scratch panel, plug in the new value, run the test again.
- Repeat this iteration cycle until the query is where it needs to be.
And the steps where I just move the query being built over to the scratch panel and back over and over and over feels like a distraction and needless busy work. If I could just have two Query Editor panes, and run my little SELECTs to find values in the second panel, there's be one less little chore dragging me out of flow state.
Is there some way of getting a second Query Editor panel in pgAdmin?
Or is there some alternate development habit I could be using so I wouldn't feel the need for one?
