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
