psql tab completion for \h with IMPORT FOREIGN SCHEMA

Michael Paquier <michael@paquier.xyz>

From: Michael Paquier <michael@paquier.xyz>
To: Postgres hackers <pgsql-hackers@lists.postgresql.org>
Date: 2021-03-18T06:58:46Z
Lists: pgsql-hackers

Attachments

Hi all,

Well, as $subject tells, I just found confusing that \h does not
complete the so-said command, the only one using IMPORT as keyword,
so I'd like to do the following:
--- a/src/bin/psql/tab-complete.c
+++ b/src/bin/psql/tab-complete.c
@@ -1493,7 +1493,7 @@ psql_completion(const char *text, int start, int end)
         "ABORT", "ALTER", "ANALYZE", "BEGIN", "CALL", "CHECKPOINT", "CLOSE", "CLUSTER",
         "COMMENT", "COMMIT", "COPY", "CREATE", "DEALLOCATE", "DECLARE",
         "DELETE FROM", "DISCARD", "DO", "DROP", "END", "EXECUTE", "EXPLAIN",
-        "FETCH", "GRANT", "IMPORT", "INSERT", "LISTEN", "LOAD", "LOCK",
+        "FETCH", "GRANT", "IMPORT FOREIGN SCHEMA", "INSERT", "LISTEN", "LOAD", "LOCK",
         "MOVE", "NOTIFY", "PREPARE",
         "REASSIGN", "REFRESH MATERIALIZED VIEW", "REINDEX", "RELEASE",
         "RESET", "REVOKE", "ROLLBACK",

That's not the patch of the year.

Thanks,
--
Michael

Commits

  1. Improve tab completion of IMPORT FOREIGN SCHEMA with \h in psql