Re: [BUGS] Bug #718: request for improvement of /? to show /d+ /l+

Folks, I discussed with Harald a month ago how to improve the psql \?
display. I have implemented his idea of mentioning '+' for the options
that can use it, and that is in CVS.

His other idea is to group the backslash commands into sections, so they
are not all one big alphabetical list.

How do people like the idea of grouping them? I would do it in psql \?
and in the psql manual page.

---------------------------------------------------------------------------

Harald Armin Massa wrote:
> But there could really be an improvement of the psql help by grouping the
> commands after "Areas of interest" instead of sorting on alphabet. I have
> done a first try:
>
> Servers, Connections
> \c[onnect] [DBNAME|- [USER]]
> connect to new database (currently "test")
> \h NAME help on syntax of SQL commands, * for all commands
> \g FILENAME send SQL command to server (and write results to file or
> |pipe)
> \copy ... perform SQL COPY with data stream to the client host
> \cd [DIRNAME] change the current working directory
> \! [COMMAND] execute command in shell or start interactive shell
> \encoding ENCODING set client encoding
> \set NAME VALUE set internal variable
> \unset NAME unset (delete) internal variable
> \q quit psql
>
>
> Information Functions
> \copyright show PostgreSQL usage and distribution terms
> \d TABLE describe table (or view, index, sequence)
> \d{t|i|s|v}... list tables/indexes/sequences/views (add + for extended)
> \d{p|S|l} list access privileges, system tables, or large objects
> \da list aggregate functions
> \dd NAME show comment for table, type, function, or operator
> \df list functions
> \do list operators
> \dT list data types
> \l list all databases (add + for extended output)
> \z list table access privileges
> \d+ extended List
> \l+
>
> Query Buffer
> \r reset (clear) the query buffer
> \e FILENAME edit the current query buffer or file with external editor
> \i FILENAME execute commands from file
> \p show the content of the current query buffer
> \w FILENAME write current query buffer to file
>
>
> Large Object
> \lo_export, \lo_import, \lo_list, \lo_unlink
> large object operations
>
> Output and Formatting
> \o FILENAME send all query results to file or |pipe
> \a toggle between unaligned and aligned output mode
> \f STRING set field separator
> \t show only rows (currently off)
> \x toggle expanded output (currently off)
> \echo TEXT write text to standard output
> \qecho TEXT write text to query output stream (see \o)
> \s FILENAME print history or save it to file
> \C TITLE set table title
> \H toggle HTML output mode (currently off)
> \T TEXT set HTML table tag attributes
> \pset VAR set table output option (VAR := {format|border|expanded|
> fieldsep|null|recordsep|tuples_only|title|tableattr|pager})

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073