diff options
author | Tomas Vondra <tomas.vondra@postgresql.org> | 2024-12-16 18:12:29 +0100 |
---|---|---|
committer | Tomas Vondra <tomas.vondra@postgresql.org> | 2024-12-16 18:47:03 +0100 |
commit | 3429145d42e0aee0565328c8ca8378ed17b300dc (patch) | |
tree | 0b81c81ed44ca72e7ecf6c1756d0efad7ffa2c42 | |
parent | a01f6fa6ad5e232e1bd38c05d443875ae3ba7ee8 (diff) | |
download | postgresql-3429145d42e0aee0565328c8ca8378ed17b300dc.tar.gz postgresql-3429145d42e0aee0565328c8ca8378ed17b300dc.zip |
psql: Tab completion for JOIN ... USING column list
For JOIN ... USING, offer attribute names for the first member of the
column list.
Author: Andreas Karlsson
Reviewed-By: Tomas Vondra
Discussion: https://postgr.es/m/3a7e27bc-d6ed-4cb0-9b21-f21143fc1b37@proxel.se
-rw-r--r-- | src/bin/psql/tab-complete.in.c | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/src/bin/psql/tab-complete.in.c b/src/bin/psql/tab-complete.in.c index e9af7b37ac8..31c77214b4f 100644 --- a/src/bin/psql/tab-complete.in.c +++ b/src/bin/psql/tab-complete.in.c @@ -5179,6 +5179,10 @@ match_previous_words(int pattern_id, TailMatches("JOIN", MatchAny, MatchAny, "USING") || TailMatches("JOIN", "LATERAL", MatchAny, MatchAny, "USING")) COMPLETE_WITH("("); + else if (TailMatches("JOIN", MatchAny, "USING", "(")) + COMPLETE_WITH_ATTR(prev3_wd); + else if (TailMatches("JOIN", MatchAny, MatchAny, "USING", "(")) + COMPLETE_WITH_ATTR(prev4_wd); /* ... AT [ LOCAL | TIME ZONE ] ... */ else if (TailMatches("AT")) |