Skip site navigation (1) Skip section navigation (2)

Re: Friendly help for psql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-patches(at)postgresql(dot)org, Greg Sabino Mullane <greg(at)turnstep(dot)com>
Subject: Re: Friendly help for psql
Date: 2008-01-20 19:08:42
Message-ID: 10906.1200856122@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Greg Sabino Mullane wrote:
>> Why not run help when someone enters "help" (or "HELP ME!") on the
>> command line? \? is hardly an easy thing to remember (and some people
>> can't be bothered to actually read the screen...)

> Then surely the help output won't be of use to them either.

The actual argument for doing this is nothing more nor less than
"mysql does it like that".  99% of the people who will tell you this
is user-friendly think so because they used mysql before coming to
postgres.

That might be sufficient reason to do it; I'm not sure.  Personally
I find it a really bad idea for psql to be usurping syntax that
doesn't start with a backslash, but I don't suppose I'm representative
of people who haven't absorbed the difference between psql and SQL.

Note that the mysql help facility covers both the mysql program and SQL
commands (ie both \? and \h in our terminology) so the proposed patch
is going to be seen as pretty lacking anyway by mysql-trained users.

It's interesting to note that "help", "\h", and "\?" all provoke the
same response(s) in mysql.  Perhaps a patch that had had more than two
seconds' design effort in it would do the same in psql; though I'm not
sure what to do to disambiguate the case with no arguments.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Simon RiggsDate: 2008-01-20 19:31:41
Subject: Re: Transaction Snapshot Cloning
Previous:From: Joe ConwayDate: 2008-01-20 18:47:12
Subject: Re: [GENERAL] SHA1 on postgres 8.3

pgsql-patches by date

Next:From: Alvaro HerreraDate: 2008-01-20 19:41:41
Subject: Re: Friendly help for psql
Previous:From: Peter EisentrautDate: 2008-01-20 18:34:20
Subject: Re: Friendly help for psql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group