Re: How about a psql backslash command to show GUCs?

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: How about a psql backslash command to show GUCs?
Дата
Msg-id CAM-w4HMNVDP7f3667atf62E7LNrriq_5D+HBiVgmg+QEcd-22w@mail.gmail.com
обсуждение исходный текст
Ответ на How about a psql backslash command to show GUCs?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Wed, 6 Apr 2022 at 13:50, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> when I want to see some related parameters, or when I'm a bit
> fuzzy on the exact name of the parameter.  Not only is this
> a lot of typing, but unless I'm willing to type even more to
> avoid using "*", I'll get a wall of mostly unreadable text,
> because pg_settings is far too wide and cluttered with
> low-grade information.

I may be suffering from some form of the Mandela Effect but I have a
distinct memory that once upon a time SHOW actually took patterns like
\d does. I keep trying it, forgetting that it doesn't actually work.
I'm guessing my brain is generalizing and assuming SHOW fits into the
same pattern as \d commands and just keeps doing it even after I've
learned repeatedly that it doesn't work.

Personally I would like to just make the world match the way my brain
thinks it is and make this just work:

SHOW enable_*

I don't see any value in allowing * or ? in GUC names so I don't even
see a downside to this. It would be way easier to discover than
another \ command

-- 
greg



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How about a psql backslash command to show GUCs?
Следующее
От: Lukas Fittl
Дата:
Сообщение: Re: shared-memory based stats collector - v70