RE: Support tab completion for upper character inputs in psql

From: "Tang, Haiying" <tanghy(dot)fnst(at)cn(dot)fujitsu(dot)com>
To: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, "tgl(at)sss(dot)pgh(dot)pa(dot)us" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: RE: Support tab completion for upper character inputs in psql
Date: 2021-02-08 12:12:35
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

At Sun, 07 Feb 2021 13:55:00 -0500, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote in
> This looks like you're trying to force case-insensitive behavior
> whether that is appropriate or not. Does not sound like a good idea.

Thanks for your reply.
I raise this issue because I thought all SQL command should be case-insensitive.
And the set/reset/show commands work well no matter the input configuration parameter is in upper or in lower case.
My modification is not good enough, but I really think it's more convenient if we can support the tab-completion for upper character inputs.

=# set APPLICATION_NAME to test;

=# show APPLICATION_name;
(1 row)

From: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
Sent: Monday, February 8, 2021 5:02 PM

>However set doesn't. If it is what is wanted, the following change on Query_for_list_of_set_vars works (only for the case of SET/RESET commands).

Thanks for your update. I applied your patch, it works well for SET/RESET commands.
I added the same modification to SHOW command. The new patch(V2) can support tab completion for upper character inputs in psql for SET/RESET/SHOW commands.


Attachment Content-Type Size
V2-0001-Support-tab-completion-for-upper-character-inputs-in.patch application/octet-stream 1.2 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message John Naylor 2021-02-08 13:14:44 Re: [POC] verifying UTF-8 using SIMD instructions
Previous Message Dilip Kumar 2021-02-08 11:35:52 Re: Is Recovery actually paused?