Request a Demo
Home   >   mailing lists

Re: Add MERGE and VALUES statements to tab completion for PREPARE - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: Add MERGE and VALUES statements to tab completion for PREPARE
Date
Msg-id CAHGQGwF7zy9MTjTJkpGom7ADNxe=CRfhXQvjqgAaXsRM3qGXsw@mail.gmail.com
Whole thread Raw
In response to Add MERGE and VALUES statements to tab completion for PREPARE  (Haruna Miwa <miwa@sraoss.co.jp>)
List pgsql-hackers
Tree view 
On Mon, Nov 10, 2025 at 9:41 AM Haruna Miwa <miwa@sraoss.co.jp> wrote:
>
> Hi,
>
> As described in the manual[1], PREPARE ... AS command supports MERGE and VALUES statements, but current psql's tab
completiondoes 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

pgsql-hackers by date:

Previous
From: Sergey Tatarintsev
Date:
Subject: pg_getaddrinfo_all() with hintp=NULL
Next
From: Akshay Joshi
Date:
Subject: Re: [PATCH] Add pg_get_policy_ddl() function to reconstruct CREATE POLICY statement