Improve tab completion for COPY

From: torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>
To: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Improve tab completion for COPY
Date: 2025-05-07 06:39:26
Message-ID: 079e7a2c801f252ae8d522b772790ed7@oss.nttdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I noticed that REJECT_LIMIT, an option available for COPY FROM, is not
currently supported in psql's tab completion.

Additionally, some options are only valid for COPY FROM or COPY TO, i.e.
FREEZE, ON_ERROR, FORCE_QUOTE, but psql currently suggests them for both
COPY FROM and COPY TO.
As the number of COPY options continues to grow, I feel that having
irrelevant suggestions makes tab completion noisier.

Attached patch splits the tab completion rules between COPY FROM and
COPY TO, so that only the appropriate options are suggested for each.

What do you think?

Regards,

--
Atsushi Torikoshi
Seconded from NTT DATA GROUP CORPORATION to SRA OSS K.K.

Attachment Content-Type Size
v1-0001-Improve-tab-completion-for-COPY-WITH-options.patch text/x-diff 2.5 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Gustafsson 2025-05-07 06:54:48 Re: disabled SSL log_like tests
Previous Message Cédric Villemain 2025-05-07 06:13:44 Re: minor fix related to Auxiliary processes and IO workers