Re: Improved psql tab completion for joins

Tomas Vondra <tomas@vondra.me>

From: Tomas Vondra <tomas@vondra.me>
To: Andreas Karlsson <andreas@proxel.se>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2024-12-07T23:06:08Z
Lists: pgsql-hackers
Hi,

On 11/16/24 17:59, Andreas Karlsson wrote:
> Hi,
> 
> Here is a set of small patches which improve the tab completion of joins
> in psql. The completion of select queries and DML is very primitive in
> psql but since we already have completion of relation names after FROM
> and JOIN I think these small additions fit and at least I find them
> useful myself. I don't use USING that much in application code but when
> writing ad hoc queries I use it quite a bit.
> 
> ## 0001-Complete-LATERAL-keyword-for-joins.patch
> 
> Adds support for the LATERAL keyword after JOIN.
> 
> ## 0002-Complete-ON-and-USING-keywords-for-joins.patch
> 
> Adds completion of the ON and USING keywords.
> 
> ## 0002-Complete-ON-and-USING-keywords-for-joins.patch
> 
> Adds completion of the first USING column.
> 

Thanks. On a cursory look these all seem reasonable to me. I'll do a bit
more review to make sure I didn't miss anything, and then I intend to
get this committed ...


regards

-- 
Tomas Vondra




Commits

  1. psql: Tab completion for JOIN ... ON/USING

  2. psql: Tab completion for JOIN ... USING column list

  3. psql: Tab completion for LATERAL joins