Re: psql tab completion for user functions and if explicitly required also "pg_"

On Tue, 30 Jun 2026 at 14:22, Florin Irion <irionr(at)gmail(dot)com> wrote:
>
> Hello,
>
> I think it would be nice to have tab completion for user functions after
> `SELECT`, and also for `pg_` in some cases. There was already a
> discussion around this here
> https://www.postgresql.org/message-id/CACLU5mQBYaMgGzJ-ZoG4MrBuXLsREcQbiY4pqsnYjMaMQP6hQg%40mail.gmail.com ,
> however as that discussion is ~ 1 year old I thought it's better to
> start a new one.
>
> Attaching a patch, keeping in mind some doubts that were expressed in
> the old discussion.
>

It needed a rebase. Also, the patch didn't apply directly, I fixed the
offset and there was a corruption in the file I couldn't fix.

$ git am ~/Downloads/v1-0001-Add-function-name-tab-completion-after-SELECT-in-.patch
Applying: Add function name tab completion after SELECT in psql
error: corrupt patch at line 30
Patch failed at line 30.

In the end, after I fixed the offset, I applied the commit by hand,
committed the change and squashed it into a single commit to produce
the patch again.
Let me know please if you find any errors. I'll check into the code
now, this was my first attempt to only rebase into latest changes and
make cfboot hopefully happy.

>
> Cheers,
>
> Florin Irion
> https://www.enterprisedb.com

--
Mario Gonzalez
EDB: https://www.enterprisedb.com