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

From Pavel Stehule
Subject Re: psql suggestion "select " offers nothing, can we get functions like "\df "
Date
Msg-id CAFj8pRBJPf_eQFhvCMwqouU6DVwYD84rw8K03QLLXwKGGCyTTg@mail.gmail.com
Whole thread Raw
In response to Re: psql suggestion "select " offers nothing, can we get functions like "\df "  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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.


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


pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Draft for basic NUMA observability
Next
From: Alexander Lakhin
Date:
Subject: Re: SQLFunctionCache and generic plans