psql: Add tab completion for ALTER USER RESET

From: Robins Tharakan <tharakan(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: psql: Add tab completion for ALTER USER RESET
Date: 2024-11-29 08:42:29
Message-ID: CAEP4nAzqiT6VbVC5r3nq5byLTnPzjniVGzEMpYcnAHQyNzEuaw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Please find attached a patch to help tab completion show only currently set
vars
during ALTER USER RESET.

Currently tab completion provides a list of all vars which is only
partially helpful.
This patch allows tab completion to see which vars are currently set for
the role
and only show those options during tab completion.

For example:
postgres=# \drds
List of settings
Role | Database | Settings
----------+----------+-------------------------------------
postgres | | max_parallel_workers_per_gather=100+
| | max_parallel_workers=100
(1 row)

postgres=# alter user postgres reset
ALL max_parallel_workers
max_parallel_workers_per_gather

postgres=# alter user postgres reset max_parallel_workers;
ALTER ROLE

postgres=# \drds
List of settings
Role | Database | Settings
----------+----------+-------------------------------------
postgres | | max_parallel_workers_per_gather=100
(1 row)

postgres=# alter user postgres reset
ALL max_parallel_workers_per_gather

postgres=# alter user postgres reset all;
ALTER ROLE

postgres=# \drds
Did not find any settings.

Applies on master (b6612aedc53a6) / make check successful.
-
Robins Tharakan
Amazon Web Services

Attachment Content-Type Size
v1-0001-Add-tab-completion-for-ALTER-USER-RESET.patch application/octet-stream 1.4 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Guillaume Lelarge 2024-11-29 08:43:21 Re: Logging parallel worker draught
Previous Message jian he 2024-11-29 08:37:55 Re: [PATCH] Fix jsonb comparison for raw scalar pseudo arrays