Re: psql suggestion "select " offers nothing, can we get functions like "\df " - Mailing list pgsql-hackers

From Kirill Reshke
Subject Re: psql suggestion "select " offers nothing, can we get functions like "\df "
Date
Msg-id CALdSSPiCUB-pgALt6oWTngYcKAUD_J9c=u-9JJtGQB_E6gvtxQ@mail.gmail.com
Whole thread Raw
In response to Re: psql suggestion "select " offers nothing, can we get functions like "\df "  (Kirill Reshke <reshkekirill@gmail.com>)
Responses Re: psql suggestion "select " offers nothing, can we get functions like "\df "
List pgsql-hackers


On Fri, 4 Apr 2025, 16:41 Kirill Reshke, <reshkekirill@gmail.com> wrote:
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


Maybe we can tab-complete here if prefix matches pg_% ? Does that makes good use case?

pgsql-hackers by date:

Previous
From: Kirill Reshke
Date:
Subject: Re: speedup COPY TO for partitioned table.
Next
From: Andres Freund
Date:
Subject: Re: [PoC] Federated Authn/z with OAUTHBEARER