HI,
I noticed that the tab completion for ALTER STATISTICS .. SET was not
handled. The attached patch displays SCHEMA and STATISTICS for tab
completion of ALTER STATISTICS name SET.
Regards,
Vignesh
From 2177167ee74ab3748e23aac15c65b8391e73528f Mon Sep 17 00:00:00 2001
From: "vignesh.c" <vignes...@gmail.com>
Date: Tue, 18 Oct 2022 14:27:15 +0530
Subject: [PATCH v1] Tab completion for ALTER STATISTCS name SET.
Display SCHEMA and STATISTICS for tab completion of ALTER STATISTCS name SET.
---
src/bin/psql/tab-complete.c | 3 +++
1 file changed, 3 insertions(+)
diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c
index 584d9d5ae6..a64571215b 100644
--- a/src/bin/psql/tab-complete.c
+++ b/src/bin/psql/tab-complete.c
@@ -2216,6 +2216,9 @@ psql_completion(const char *text, int start, int end)
/* ALTER STATISTICS <name> */
else if (Matches("ALTER", "STATISTICS", MatchAny))
COMPLETE_WITH("OWNER TO", "RENAME TO", "SET SCHEMA", "SET STATISTICS");
+ /* ALTER STATISTICS <name> SET */
+ else if (Matches("ALTER", "STATISTICS", MatchAny, "SET"))
+ COMPLETE_WITH("SCHEMA", "STATISTICS");
/* ALTER TRIGGER <name>, add ON */
else if (Matches("ALTER", "TRIGGER", MatchAny))
--
2.32.0
