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 CALdSSPhARSB5DmM-9eLatG+wUkMDCu56RhErz8mB1RS4CeoDvw@mail.gmail.com
Whole thread Raw
In response to psql suggestion "select " offers nothing, can we get functions like "\df "  (Kirk Wolak <wolakk@gmail.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Дарья Шанина
Date:
Subject: autoprewarm_dump_now
Next
From: Andrei Lepikhov
Date:
Subject: Re: Memoize ANTI and SEMI JOIN inner