Re: psql suggestion "select <tab>" offers nothing, can we get functions like "\df <tab>"

Hi

čt 3. 4. 2025 v 20:17 odesílatel Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> napsal:

> Kirk Wolak <wolakk(at)gmail(dot)com> writes:
> > But "select <tab>" does nothing.
>
> What would you have it offer? Every single column and function name
> in the database? Seems unlikely to be very helpful.
>
> postgres=# select count(distinct attname) from pg_attribute;
> count
> -------
> 1218
> (1 row)
>
> postgres=# select count(distinct proname) from pg_proc;
> count
> -------
> 2787
> (1 row)
>
> That's with zero user-defined objects.
>

you can try https://www.pgcli.com/

the tab complete there is better (or different) than in psql. I don't use
it, but I know people who use it well.

I agree so tab complete for functions can be nice feature. It is a question
if it can work with readline. At the end it is always faster for me to
write \df *reset*, and using mouse for copy

Regards

Pavel

>
> regards, tom lane
>
>
>