Quick little \h enhancement for psql - Mailing list pgsql-patches

From Greg Sabino Mullane
Subject Quick little \h enhancement for psql
Date
Msg-id 1116283349.17910.1.camel@localhost.localdomain
Whole thread Raw
Responses Re: Quick little \h enhancement for psql  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-patches
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

                      

                      
Attached is a patch that enhances the "\h" capability in psql. I often
find myself typing a command and then wanting to get the syntax for
it. So I do a ctrl-a and add a \h: but psql does not recognize the
command, because I have stuff attached to it (e.g. "alter table
foobar"),
so I have to scroll over and delete everything except the name of the
command itself. This patch gives \h three chances to match: if nothing
matches the complete string (current behavior), it tries to match the
first two words (e.g. "ALTER TABLE"). If that fails, it tries to match
the first word (e.g. "DELETE").

                      
- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200505161840
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

                      
iD8DBQFCiSF3vJuQZxSWSsgRAumaAKCKd0xns4V+ITRSfxGJCrJUtZOrjgCfW8FC
qbFC2jdXGOWWP8cN3Um/1hY=
=kZeh
-----END PGP SIGNATURE-----


Attachment

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Exec statement logging
Next
From: Greg Sabino Mullane
Date:
Subject: Bunch of tab-completion enhancements for psql