140

In the Query Tool, when trying to raise or lower the border between Query Sql Editor and Data Output Panel it is very common that when you move the mouse over the Data Output panel's header it changes the vertical - horizontal arrow icon to a cross arrow changing Data Output panel from its default tiling to floating

What should I do to return the Data Output panel to its initial tiling mode?

In addition, Data Output panel once in floating window stops showing queries's results, it only shows the messages, I suppose it's 3.1's bug.

My solution so far is to save the query, close it and reopen it to recover its tiling mode

Cursor's disappearance problems have not been corrected in full

What is the best free competitor of pgadmin 4?

Ahmed Ashour
  • 5,179
  • 10
  • 35
  • 56
glicuado
  • 1,483
  • 2
  • 10
  • 11
  • 3
    A great free competitor is DBeaver Community edition. I love Postgres, but sadly PgAdmin 4 has sadly not measured up to expectations. – Hambone Aug 26 '19 at 19:41
  • 4
    Now the question even more actual as pgAdmin of modern versions remembers layout for the query tool, and reopening does not help any more :) – greatvovan Sep 04 '20 at 23:00
  • 1
    Yes, this is a very annoying feature, can't help agreeing with you! – Rocckk Nov 29 '21 at 15:14
  • 1
    Has anyone discovered how to get the rest of pgAdmin back if you inadvertently make a panel full size? I've just restarted 3 times due to inadvertent clicks. This is an amazingly poor UX. – Nello Aug 01 '22 at 02:30

10 Answers10

225

In the pgadmin browser, click on the File menu and select reset layout.

Yes, will get all kinds of warnings, but the query tool returns to being useful.

Ahmed Ashour
  • 5,179
  • 10
  • 35
  • 56
Dan
  • 2,275
  • 1
  • 6
  • 2
  • 2
    Warnings are to remind users of some things like: you'll lose your existing (executed) scripts on the current panel, and so on. Should be careful as well. – qamnott Apr 24 '21 at 08:03
  • Thank you for this. Was frustrated when this happened. – Suraj Aug 17 '21 at 09:22
  • 1
    This deletes all your open files. What a horrible solution just to re-dock a single results panel... – Cerin Feb 11 '22 at 19:30
56

I don't know in PgAdmin 4.3, but in 4.6 I found that way to re-arrange it.

First, right-click on somewhere to Add Panel -> Scratch Pad first to get a panel holder first (when clicking, notice the highlighted light blue space),

screenshot_1

then right-click the lower half space to add another panel -> Scratch Pad at the lower half space (when clicking, notice the highlighted light blue space),.

screenshot_2

After that, click on the tab and hold to drag and drop to where you want (when clicking, notice the highlighted light blue space).

screenshot_3

Naveen
  • 360
  • 1
  • 8
  • 23
qamnott
  • 691
  • 5
  • 5
  • 8
    What I was missing is that holding the mouse button down over the name of the tab switches to move-this-tab mode. – Jamie Fristrom Jun 30 '19 at 20:13
  • Awesome, I can use the program again. – greatvovan Jul 10 '19 at 23:30
  • 4
    @JamieFristrom - this comment should be the answer! – sppc42 Aug 06 '19 at 11:51
  • Great that it helps! – qamnott Aug 27 '19 at 03:29
  • 1
    As of version 4.25, I could not make it work. "Reset Layout" works though, but it is so annoying... – greatvovan Sep 04 '20 at 23:24
  • @greatvovan, I just tested and it still works on 4.25. – qamnott Oct 09 '20 at 03:54
  • I just tested on pgAdmin 4 version 5.2, "File --> Reset Layout" is the last way to fix this. You can avoid accidentally move/drag a panel by going to "File --> Lock Layout --> Full Lock", so panels cannot be dragged/moved. You can choose "None" to leave it drag-able. Panels are still drag-able from its default docking position to other dock-able position while you still holding your dragging click. If you release the dragging click before docking at a new dock-able posting, then it seems that panel cannot dock at any position. When too messed up, go to "Reset Layout". – qamnott Apr 24 '21 at 07:58
40

I have pgadmin 4.15 and I found how to resolve this. On the upper left corner, click on File dropdown and then click on Reset Layout. It will ask to restart the application, click Ok.

Muhammad Akhtar
  • 401
  • 4
  • 4
16

No this is not a bug, those panels are meant to be floatable so that user can arrange the view as per their convince.

But yes user should have the option to lock the layout, and I see feature request for locking the layout is already in the pgadmin4 list. Hopefully, we will get it in the next future release. Ref: https://redmine.postgresql.org/issues/3155

------ UPDATE -----

  1. Now you can lock the layout in pgAdmin4 (File menu -> Lock layout) option

  2. To reset the panels to default position (File manu -> Reset Layout) option

------ UPDATE-2021 -----

This issue has been fixed, can you please check with pgAdmin4 v5.5 which is released on 15-july-2021.

Murtuza Z
  • 5,639
  • 1
  • 28
  • 52
  • 5
    thanks, is there a way to return the floating panel to tiling ?; for me today the floating panel is unusable, I run the queries and it does not show results. Why floats do not have window options on the right side of their header? minimize, maximize, close, retiling? it would be very convenient – glicuado Jul 05 '18 at 11:59
  • You can again drag & drop the panel to its original location. – Murtuza Z Jul 05 '18 at 16:01
  • 5
    Even by dragging and dropping to its original location, the window is still floating? How can I dock/pin after it is floating? I'm using pgAdmin 4.5 on mac. – axiopisty Apr 17 '19 at 19:46
  • 1
    It's still the case as of 4.5 – Chapo May 13 '19 at 06:24
  • Could the topic starter @glicuado set this as accepted answer? Reset Layout actually worked for me – Yar Jul 09 '21 at 15:44
  • Reset Layout throws away all your current work. It's not a fix, just another bug. – Nello Oct 12 '22 at 02:42
  • This is an infuriatingly simple missing feature. Why isn't there just a "re-dock" button on the floating window bar?? – shadowtalker Aug 16 '23 at 13:49
2

Long press with left mouse button on title permits you to reposition the panel in layout

Alessandro Battistini
  • 762
  • 5
  • 11
2

reset is also available as an icon on the top right area of the UI

wromma
  • 21
  • 1
  • 5
1

File dropdown >> Reset Layout (reload issue) this will reload but the changes/query will be lost. Better to store the query somewhere else before resetting layout

Milan
  • 31
  • 4
0

I'm still on 4.2.6, and as long as only one of the tabs has floated, I can click on the text "Data Output", and drag it onto the tab bar of the bottom panel. Note that you need to click the text, and not just anywhere in the panel's top bar, it acts as a kind of invisible tab.

If the other tabs (Explain, etc) have also floated I think you need a 'Scratch Pad' or Reset.

Then File, Lock Layout, Prevent Docking if this is never useful for you.

Chris
  • 5,664
  • 6
  • 44
  • 55
0

I was able to redock it in pgadmin 4, version 6.0 by dragging the floating window down to the bottom right of the screen. I drug it around down there until it started highlighting docking arrangements for it and it eventually shows a highlight for the original docking position and then you can let go and it'll dock. Not super exact instructions, but once you do it a couple times it's easy to recreate.

Joseph Hawkes-Cates
  • 1,911
  • 2
  • 12
  • 13
0

Running pgAdmin4 on Apple M1 Pro, Ventura > 13 click the half-circle with an arrow at the 12 o'clock position in the top right corner of the app. Hovering over the button reveals "Reset layout".

reset layout is button in top right of picture and app

Nick Thompson
  • 1
  • 1
  • 2