Re: Friendly help for psql

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Re: Friendly help for psql
Date: 2008-01-22 06:18:07
Message-ID: 88927e8fcef11e27ce73dadcfbbdd9dc@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches


-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

>> No. While the original poster may have been making a separate comparison
>> to MySQL, I can assure you that my impetus for doing this is not being
>> driven by the behavior of the mysql client.

> Then what is the motivation for this? We have many sources of help. I have
> never heard of any user not being able to find help.

Maybe you need to get out in the trenches more, I've seen users confused
at the psql prompt.

>> Having "help" do something
>> other than throw a syntax error is a very common feature in many
>> interactive programs, for example openssl, gdb, ftp, bash, mail,
>> telnet, and vim.

> The difference with these tools is that they don't already tell you how to get
> help when you log in.
>
> Now I have actually thought for a while whether we could get rid of the login
> text altogether. I would support trading that for extended help options.
> But if the login note is there, then we don't need more help options.

What about when the login note is no longer available? New person logs on,
issues a select * from customer; then tries to remember how to view all the tables.
Or how to quit. Their first instinct is "help" - no reason we cannot support that;
it does no harm at all to people who don't use it. Another use case: someone has a
'screen' session open to a psql prompt, and sends someone else in to it, or comes
back later on. Same thing: the login note is no longer available ('screen' has a
small scrollback), and even if you've used it before, "backslash question mark"
is, let's be honest, very obscure, unintuitive, and hard to remember.

I'd support an alternative text rather than "slashusage" as long as something
is put into place.

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200801220101
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFHlYorvJuQZxSWSsgRA9TNAKDbXm/NLCoM6DFJDsVppjhu0be2VgCeL3Zr
I1lnq4VCw5+5pG20rJgvCvM=
=S9x4
-----END PGP SIGNATURE-----

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message cinu 2008-01-22 11:52:08 Errors with run_build.pl - 8.3RC2
Previous Message Julio Cesar Sánchez González 2008-01-22 05:26:58 Re: SHA1 on postgres 8.3

Browse pgsql-patches by date

  From Date Subject
Next Message Alvaro Herrera 2008-01-22 15:42:39 Re: Thoughts about bug #3883
Previous Message Tom Lane 2008-01-21 23:01:04 Thoughts about bug #3883