Query Tool window, connection dropdown: prefill with available connections? (RM #7433)

[dpage]

Issue migrated from Redmine: https://redmine.postgresql.org/issues/7433 Originally created by Franz-Josef Färber at 2022-05-31 06:20:01 UTC.

Suggestion:

In the Query Tool window, connection dropdown field:

This dropdown initially just contains the current connection. To add other connections, one has to do several mouse clicks.

What about pre-filling the dropdown with all connections (as in the "browser" left sidebar?)

This would facilitate my workflow (i. e. easily execute the same SQL statements on different servers)

Regards, fjf2002

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7433#note-1 Originally created by Akshay Joshi at 2022-06-03 11:12:14 UTC.

Hi Franz

This is by design, there can be multiple databases/user combinations. What kind of combination do you propose?

Redmine ticket header update:

Name	Old Value	New Value
Assigned To changed		Franz-Josef Färber

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7433#note-2 Originally created by Franz-Josef Färber at 2022-06-03 15:52:32 UTC.

I have pgadmin running with five connections in the left sidebar. These do not just contain the host name, but also the username and password. Just as in /pgadmin4/servers.json, you know?

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7433#note-3 Originally created by Aditya Toshniwal at 2022-06-06 04:31:31 UTC.

Franz-Josef Färber wrote:

I have pgadmin running with five connections in the left sidebar. These do not just contain the host name, but also the username and password. Just as in /pgadmin4/servers.json, you know?

The connections on left sidebar are used to connect to server. But, a server can have multiple databases and multiple roles. Although we cannot list down all the database roles combinations, but listing only left ones can be considered.

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7433#note-4 Originally created by Nikhil Mohite at 2022-06-24 11:49:21 UTC.

No response from the author, hence rejecting it.

Redmine ticket header update:

Name	Old Value	New Value
Assigned To changed	Franz-Josef Färber
Status changed	New	Rejected

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7433#note-5 Originally created by Franz-Josef Färber at 2022-06-24 11:54:30 UTC.

I had not answered because there was no question.

but listing only left ones can be considered. With "left ones" you mean the ones in the left sidebar, i. e. the database-role-combinations there? Sound good.

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7433#note-6 Originally created by Khushboo Vashi at 2022-06-27 04:17:16 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Status changed	Rejected	New

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7433#note-7 Originally created by Akshay Joshi at 2022-07-01 11:24:45 UTC.

We can add one preference setting for this.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed		Ready

[dpage]

Issue closed on Redmine.

[fjf2002]

Sorry, but I am now using pgadmin4 6.14, and I can't find this feature. How do I activate it?

[adityatoshniwal]

This is not implemented yet. Looks like it was closed when migrating to github.