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

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: psql suggestion "select " offers nothing, can we get functions like "\df "
Дата
Msg-id CAFj8pRBJPf_eQFhvCMwqouU6DVwYD84rw8K03QLLXwKGGCyTTg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: psql suggestion "select " offers nothing, can we get functions like "\df "  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления: