Re: [BUGS] Bug #718: request for improvement of /? to show - Mailing list pgsql-patches

Peter Eisentraut wrote:
> Bruce Momjian writes:
>
> > OK, I have created an "I/O  Redirection" section and moved \i and \o
> > into there.  I didn't think \s (history) belonged there.  I also
> > couldn't see \copy as I/O redirection.  (It is a shotgun wedding,
> > though.)
>
> How about just "Input/Output" without any redirection?

Good idea.

> And also put the things in each group in some sensible order.

Oh, you like them alphabetical within sections --- done.

> And I think that a two-space indent would look better.  Possibly because
> it is consistent with other help output.

Done.

>
> Take a look at psql --help.  It has much of this already done.

New output attached.  Change applied.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
General
  \c[onnect] [DBNAME|- [USER]]
                connect to new database (currently "test")
  \cd [DIR]      change the current working directory
  \copyright     show PostgreSQL usage and distribution terms
  \encoding [ENCODING]  show or set client encoding
  \h [NAME]      help on syntax of SQL commands, * for all commands
  \q             quit psql
  \set [NAME [VALUE]]  set internal variable, or list all if no parameters
  \timing        toggle timing of commands (currently off)
  \unset NAME    unset (delete) internal variable
  \! [COMMAND]   execute command in shell or start interactive shell

Query Buffer
  \e [FILE]      edit the query buffer (or file) with external editor
  \g [FILE]      send query buffer to server (and results to file or |pipe)
  \p             show the contents of the query buffer
  \r             reset (clear) the query buffer
  \s [FILE]      display history or save it to file
  \w [FILE]      write query buffer to file

Input/Output
  \i FILE        execute commands from file
  \o FILE        send all query results to file or |pipe

Informational
  \d [NAME]      describe table, index, sequence, or view
  \d{t|i|s|v|S} [PATTERN] (add "+" for more detail)
                 list tables/indexes/sequences/views/system tables
  \da [PATTERN]  list aggregate functions
  \dc [PATTERN]  list conversions
  \dC            list casts
  \dd [PATTERN]  show comment for object
  \dD [PATTERN]  list domains
  \df [PATTERN]  list functions (add "+" for more detail)
  \do [NAME]     list operators
  \dl            list large objects, same as \lo_list
  \dp [PATTERN]  list table access privileges
  \dT [PATTERN]  list data types (add "+" for more detail)
  \du [PATTERN]  list users
  \l             list all databases (add "+" for more detail)
  \z [PATTERN]   list table access privileges (same as \dp)

Formatting
  \a             toggle between unaligned and aligned output mode
  \C [STRING]    set table title, or unset if none
  \echo [STRING] write string to standard output
  \f [STRING]    show or set field separator for unaligned query output
  \H             toggle HTML output mode (currently off)
  \pset NAME [VALUE]  set table output option
                 (NAME := {format|border|expanded|fieldsep|null|recordsep|
                 tuples_only|title|tableattr|pager})
  \qecho [STRING]  write string to query output stream (see \o)
  \t             show only rows (currently off)
  \T [STRING]    set HTML <table> tag attributes, or unset if none
  \x             toggle expanded output (currently off)

Copy, Large Object
  \copy ...      perform SQL COPY with data stream to the client host
  \lo_export
  \lo_import
  \lo_list
  \lo_unlink     large object operations