Improved psql tab completion for joins

From: Andreas Karlsson <andreas(at)proxel(dot)se>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Improved psql tab completion for joins
Date: 2024-11-16 16:59:18
Message-ID: 3a7e27bc-d6ed-4cb0-9b21-f21143fc1b37@proxel.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Andreas

Attachment Content-Type Size
0001-Complete-LATERAL-keyword-for-joins.patch text/x-patch 826 bytes
0002-Complete-ON-and-USING-keywords-for-joins.patch text/x-patch 1.4 KB
0003-Complete-first-member-of-USING-column-list.patch text/x-patch 963 bytes

Browse pgsql-hackers by date

  From Date Subject
Next Message Kirill Reshke 2024-11-16 17:10:00 Re: Index AM API cleanup
Previous Message Dmitry Dolgov 2024-11-16 16:22:14 Re: Improving btree performance through specializing by key shape, take 2