> Should we suggest "MERGE INTO" instead of just "MERGE",
> since INTO always follows MERGE?
>
> Also, how about adding "TABLE" and "WITH" to the suggestions,
> similar to the tab-completion for "COPY ("?
> SELECT statement can be specified in the PREPARE command,
> and it can start with SELECT, TABLE, or WITH [1].Agreed. I have updated the patch. Regards, -- Haruna Miwa ________________________________ 差出人: Fujii Masao <[email protected]> 送信: 2025 年 11 月 10 日 (月曜日) 14:15 宛先: Haruna Miwa <[email protected]> Cc: [email protected] <[email protected]> 件名: Re: Add MERGE and VALUES statements to tab completion for PREPARE On Mon, Nov 10, 2025 at 9:41 AM Haruna Miwa <[email protected]> wrote: > > Hi, > > As described in the manual[1], PREPARE ... AS command supports MERGE and > VALUES statements, but current psql's tab completion does not suggest them. > I created a patch that enables MERGE and VALUES to appear as tab completion > suggestions. > > What do you think? +1 Should we suggest "MERGE INTO" instead of just "MERGE", since INTO always follows MERGE? Also, how about adding "TABLE" and "WITH" to the suggestions, similar to the tab-completion for "COPY ("? SELECT statement can be specified in the PREPARE command, and it can start with SELECT, TABLE, or WITH [1]. Regards, [1] https://www.postgresql.org/docs/devel/sql-select.html Regards, -- Fujii Masao
v2-0001-Add-MERGE-VALUES-WITH-and-TABLE-to-PREPARE-tab-co.patch
Description: v2-0001-Add-MERGE-VALUES-WITH-and-TABLE-to-PREPARE-tab-co.patch
