Thread: Forcing autocomplete on keypress

We have a docker setup for pgadmin and we want to force autocomplete on keypress at launch (not through the preferences) using an environment variable or config of some sort. I tried modifying the file at https://github.com/pgadmin-org/pgadmin4/blob/master/web/pgadmin/tools/sqleditor/utils/query_tool_preferences.py#L792 and replacing False with True and this works but then breaks postgres in other ways. Is there a proper way of doing this beyond modifying this file?

Thank you for the advice Aditya. I managed to get it working by adding an extra line in my docker entrypoint although it does slow the process down a little when launching the container

python3 /usr/local/lib/python3.10/dist-packages/pgadmin4/setup.py load-servers "/usr/local/lib/python3.10/dist-packages/pgadmin4/servers.json"

python3 /usr/local/lib/python3.10/dist-packages/pgadmin4/setup.py set-prefs pgadmin4@pgadmin.org sqleditor:auto_completion:autocomplete_on_key_press=true

My concerns with overriding the preference file path was that I then have to manage the ownership permissions of the file that is created which is tedious as we run various different users in production.

Thank you for pointing me in the right direction though!

---

From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Sent: Tuesday, 3 December 2024 7:53 PM
To: Zac Warham <cazwarham@hotmail.com>
Cc: pgadmin-support@lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Subject: Re: Forcing autocomplete on keypress

 

Hi Zac,

You can use PGADMIN_PREFERENCES_JSON_FILE in https://www.pgadmin.org/docs/pgadmin4/8.13/container_deployment.html

On Wed, Dec 4, 2024 at 12:45 AM Zac Warham <cazwarham@hotmail.com> wrote:

We have a docker setup for pgadmin and we want to force autocomplete on keypress at launch (not through the preferences) using an environment variable or config of some sort. I tried modifying the file at https://github.com/pgadmin-org/pgadmin4/blob/master/web/pgadmin/tools/sqleditor/utils/query_tool_preferences.py#L792 and replacing False with True and this works but then breaks postgres in other ways. Is there a proper way of doing this beyond modifying this file?

--

Thanks,

Aditya Toshniwal

pgAdmin Hacker | Sr. Staff SDE II | enterprisedb.com

"Don't Complain about Heat, Plant a TREE"