Tab completion for large objects

From: Dagfinn Ilmari Mannsåker <ilmari(at)ilmari(dot)org>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Tab completion for large objects
Date: 2025-07-08 18:50:05
Message-ID: 87y0syikki.fsf@wibble.ilmari.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi hackers,

I noticed that psql's tab completion suggested TO immediately after
GRANT ... ON LARGE OBJECT, and not after ON LARGE OBJECT <oid>. This is
because LARGE OBJECT is the only two-word object type, so it thinks
LARGE is the object type and OBJECT is the name. Attached are three
patches that address this and other LO-related tab completion issues:

1. Tab complete OBJECT after GRANT|REVOKE ... ON LARGE, and TO/FROM
after GRANT|REVOKE ... ON LARGE OBJECT

2. Tab complete filenames after \lo_export <oid>

3. Tab complete large object OIDs where relevant. This is less useful
than completing names like for other objects, but it might still
be handy. Separate patch in case it proves controversial or is
deemed useless.

- ilmari

Attachment Content-Type Size
0001-Improve-tab-completion-around-GRANT-REVOKE-.-ON-LARG.patch text/x-diff 1.9 KB
0002-Tab-complete-filenames-after-lo_export-oid.patch text/x-diff 969 bytes
0003-Add-tab-completion-for-large-object-OIDs.patch text/x-diff 1.8 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2025-07-08 18:54:33 Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem)
Previous Message Konstantin Knizhnik 2025-07-08 18:38:01 Re: Logical replication prefetch