Thread: psql suggestion "select " offers nothing, can we get functions like "\df "
Hackers,
"call <tab>" works. Obviously it was a trivial case.
But "select <tab>" does nothing.
Worse, "select pg_stat_st<tab>" has no clue. I was looking for ... _reset
It's not that difficult to add, I am suggesting that we use the same logic as \df at that point?
Is there any such support for this?
Is it bad form to offer a bounty for someone to do this in this list? (I simply won't have time for 2-3 months).
Thanks!
Kirk Wolak <wolakk@gmail.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.
regards, tom lane
Re: psql suggestion "select " offers nothing, can we get functions like "\df "
From
Pavel Stehule
Date:
Hi
čt 3. 4. 2025 v 20:17 odesílatel Tom Lane <tgl@sss.pgh.pa.us> napsal:
Kirk Wolak <wolakk@gmail.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
Pavel
regards, tom lane
Re: psql suggestion "select " offers nothing, can we get functions like "\df "
From
Kirill Reshke
Date:
On Thu, 3 Apr 2025 at 20:07, Kirk Wolak <wolakk@gmail.com> wrote: > Worse, "select pg_stat_st<tab>" has no clue. I was looking for ... _reset > > It's not that difficult to add, I am suggesting that we use the same logic as \df at that point? Is not so simple here, because we have to try to complete this query with all attributes and functions, and there can be just too many different attname in the database. For example, with 100.000 tables you probably should wait for more than one second for a psql background query to complete (and you cannot cancel it too!). So this is very questionable if this feature is worth it. -- Best regards, Kirill Reshke