Re: Idea Feedback: psql \h misses -> Offers Links?

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: Kirk Wolak <wolakk(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>
Subject: Re: Idea Feedback: psql \h misses -> Offers Links?
Date: 2024-04-19 08:45:45
Message-ID: 461ffc68-1915-45df-861c-7f128e937da4@eisentraut.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 18.04.24 23:29, Kirk Wolak wrote:
> On Thu, Apr 18, 2024 at 2:37 PM Peter Eisentraut <peter(at)eisentraut(dot)org
> <mailto:peter(at)eisentraut(dot)org>> wrote:
>
> On 17.04.24 19:47, Kirk Wolak wrote:
> > *Example:*
> > \h current_setting
> > No help available for "current_setting".
> > Try \h with no arguments to see available help.
> >
> >
> https://www.postgresql.org/search/?u=%2Fdocs%2F16%2F&q=current_setting <https://www.postgresql.org/search/?u=%2Fdocs%2F16%2F&q=current_setting>
> >
> <https://www.postgresql.org/search/?u=%2Fdocs%2F16%2F&q=current_setting <https://www.postgresql.org/search/?u=%2Fdocs%2F16%2F&q=current_setting>>
>
> One problem is that this search URL does not actually produce any
> useful
> information about current_setting.
>
> I see what you mean, but doesn't that imply our web search feature is
> weak?  That's the full name of an existing function, and it's in the
> index. But it cannot be found if searched from the website?

Maybe it's weak, or maybe we are using it wrong, I don't know.

\h has always been (a) local help, and (b) help specifically about SQL
commands. If we are going to vastly expand the scope, we need to think
it through more thoroughly. I could see some kind of \onlinehelp
command, or maybe even redesigning \h altogether.

Also, as you say, the function is in the documentation index, so there
should be a deterministic way to go directly to exactly the target
destination. Maybe the full-text search functionality of the web site
is the wrong interface for that.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bertrand Drouvot 2024-04-19 08:56:25 Re: Disallow changing slot's failover option in transaction block
Previous Message Peter Eisentraut 2024-04-19 08:34:38 Re: Cannot find a working 64-bit integer type on Illumos