Re: Improved psql tab completion for joins

From: Tomas Vondra <tomas(at)vondra(dot)me>
To: Andreas Karlsson <andreas(at)proxel(dot)se>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Improved psql tab completion for joins
Date: 2024-12-07 23:06:08
Message-ID: 37af3663-a73e-4ac8-b5a7-78f38d8d15d1@vondra.me
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2024-12-07 23:07:16 Re: Do not scan index in right table if condition for left join evaluates to false using columns in left table
Previous Message Илья Жарков 2024-12-07 23:04:01 Re: Do not scan index in right table if condition for left join evaluates to false using columns in left table