summaryrefslogtreecommitdiff
path: root/src/bin/psql/tab-complete.in.c
diff options
context:
space:
mode:
authorFujii Masao <fujii@postgresql.org>2025-11-23 23:03:53 +0900
committerFujii Masao <fujii@postgresql.org>2025-11-23 23:03:53 +0900
commit81966c5458fb0a441c69b21f63d43f04cdb0d2d6 (patch)
tree799c42fd50579006bd89ef7a287c96ea492dc63f /src/bin/psql/tab-complete.in.c
parent7d9043aee803bf9bf3307ce5f45f3464ea288cb1 (diff)
psql: Improve tab-completion for PREPARE.
This commit enhances tab-completion for PREPARE xx AS to also suggest MERGE INTO, VALUES, WITH, and TABLE. Author: Haruna Miwa <miwa@sraoss.co.jp> Reviewed-by: Fujii Masao <masao.fujii@gmail.com> Discussion: https://postgr.es/m/TY7P286MB5466B859BD6C5BE64E961878F1CEA@TY7P286MB5466.JPNP286.PROD.OUTLOOK.COM
Diffstat (limited to 'src/bin/psql/tab-complete.in.c')
-rw-r--r--src/bin/psql/tab-complete.in.c3
1 files changed, 2 insertions, 1 deletions
diff --git a/src/bin/psql/tab-complete.in.c b/src/bin/psql/tab-complete.in.c
index 51806597037..20d7a65c614 100644
--- a/src/bin/psql/tab-complete.in.c
+++ b/src/bin/psql/tab-complete.in.c
@@ -4951,7 +4951,8 @@ match_previous_words(int pattern_id,
/* PREPARE xx AS */
else if (Matches("PREPARE", MatchAny, "AS"))
- COMPLETE_WITH("SELECT", "UPDATE", "INSERT INTO", "DELETE FROM");
+ COMPLETE_WITH("SELECT", "UPDATE", "INSERT INTO", "DELETE FROM",
+ "MERGE INTO", "VALUES", "WITH", "TABLE");
/*
* PREPARE TRANSACTION is missing on purpose. It's intended for transaction