diff options
| author | Fujii Masao <fujii@postgresql.org> | 2021-09-01 22:01:15 +0900 |
|---|---|---|
| committer | Fujii Masao <fujii@postgresql.org> | 2021-09-01 22:01:15 +0900 |
| commit | b0c066297bdac901a13a5a900a197697a026b357 (patch) | |
| tree | bcdf5b7869924168d66110c4a21b2221515362f6 /src | |
| parent | 590ecd982304dec8599d6ca339903982d39a9a1a (diff) | |
| download | postgresql-b0c066297bdac901a13a5a900a197697a026b357.tar.gz postgresql-b0c066297bdac901a13a5a900a197697a026b357.zip | |
Improve tab-completion for CREATE PUBLICATION.
Author: Peter Smith
Reviewed-by: Vignesh C
Discussion: https://postgr.es/m/CAHut+Ps-vkmnWAShWSRVCB3gx8aM=bFoDqWgBNTzofK0q1LpwA@mail.gmail.com
Diffstat (limited to 'src')
| -rw-r--r-- | src/bin/psql/tab-complete.c | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c index 76462412db5..75b867685a6 100644 --- a/src/bin/psql/tab-complete.c +++ b/src/bin/psql/tab-complete.c @@ -2691,8 +2691,13 @@ psql_completion(const char *text, int start, int end) COMPLETE_WITH("FOR TABLE", "FOR ALL TABLES", "WITH ("); else if (Matches("CREATE", "PUBLICATION", MatchAny, "FOR")) COMPLETE_WITH("TABLE", "ALL TABLES"); - /* Complete "CREATE PUBLICATION <name> FOR TABLE <table>, ..." */ - else if (HeadMatches("CREATE", "PUBLICATION", MatchAny, "FOR", "TABLE")) + else if (Matches("CREATE", "PUBLICATION", MatchAny, "FOR", "ALL")) + COMPLETE_WITH("TABLES"); + else if (Matches("CREATE", "PUBLICATION", MatchAny, "FOR", "ALL", "TABLES") + || Matches("CREATE", "PUBLICATION", MatchAny, "FOR", "TABLE", MatchAny)) + COMPLETE_WITH("WITH ("); + /* Complete "CREATE PUBLICATION <name> FOR TABLE" with "<table>, ..." */ + else if (Matches("CREATE", "PUBLICATION", MatchAny, "FOR", "TABLE")) COMPLETE_WITH_SCHEMA_QUERY(Query_for_list_of_tables, NULL); /* Complete "CREATE PUBLICATION <name> [...] WITH" */ else if (HeadMatches("CREATE", "PUBLICATION") && TailMatches("WITH", "(")) |