Horton
Menu

Re: Add psql tab completion support for FOR PORTION OF

Peter Eisentraut <peter@eisentraut.org>

View thread
From: Peter Eisentraut <peter@eisentraut.org>
To: Kiran K <itskkpg@gmail.com>, pgsql-hackers@postgresql.org
Date: 2026-04-27T09:02:32Z
Lists: pgsql-hackers 
On 15.04.26 05:52, Kiran K wrote:
> Add tab completion support in psql for the FOR PORTION OF clause
> used in UPDATE and DELETE statements with temporal tables.
> Attached a patch with the changes and corresponding tests.

This looks very useful, but it seems one of the rules doesn't quite work 
in my testing:

update pg_class for portion of oid from 1 to 2 <tab>

I think you mean for this to complete AS or SET, but it offers nothing 
in my testing.  (Same with DELETE.)

(Obviously, the table and column names and values are nonsense, but they 
should work for the purpose of tab completion.)

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Add psql tab completion for FOR PORTION OF clause