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

cast patch is in the queue. I will manually apply your \? changes.

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

Christopher Kings-Lynne wrote:
> (Sent to everyone this time)
>
> What happened with the casts and conversions patch? Was it accepted? I
> think it should be committed before changing all the \d commands - it'll be
> easier.
>
> Chris
>
> ----- Original Message -----
> From: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
> To: "Harald Armin Massa" <ghum(at)gmx(dot)net>
> Cc: "PostgreSQL-patches" <pgsql-patches(at)postgresql(dot)org>
> Sent: Tuesday, December 10, 2002 1:25 PM
> Subject: Re: [PATCHES] [BUGS] Bug #718: request for improvement of /? to
> show /d+ /l+
>
>
> >
> > Here is a new psql \? output format that I would like to add for 7.4.
> > It follows Harald Armin's suggested reformatting, which you can see
> > below.
> >
> > Should I also reorder the psql manual page to match? I find the
> > grouping much easier to review.
> >
> > --------------------------------------------------------------------------
> -
> >
> >
> > General
> > \c[onnect] [DBNAME|- [USER]]
> > connect to new database (currently "test")
> > \q quit psql
> > \h [NAME] help on syntax of SQL commands, * for all commands
> > \copyright show PostgreSQL usage and distribution terms
> > \cd [DIR] change the current working directory
> > \! [COMMAND] execute command in shell or start interactive shell
> > \encoding [ENCODING] show or set client encoding
> > \set [NAME [VALUE]] set internal variable, or list all if no parameters
> > \unset NAME unset (delete) internal variable
> > \timing toggle timing of commands (currently off)
> >
> > Query Buffer
> > \g [FILE] send query buffer to server (and results to file or |pipe)
> > \r reset (clear) the query buffer
> > \e [FILE] edit the query buffer (or file) with external editor
> > \i FILE execute commands from file
> > \p show the contents of the query buffer
> > \w [FILE] write query buffer to file
> > \o FILE send all query results to file or |pipe
> > \s [FILE] display history or save it to file
> >
> > 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
> > \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)
> >
> > Large Object, Copy
> > \lo_export
> > \lo_import
> > \lo_list
> > \lo_unlink large object operations
> > \copy ... perform SQL COPY with data stream to the client host
> >
> > Formatting
> > \x toggle expanded output (currently off)
> > \a toggle between unaligned and aligned output mode
> > \f [STRING] show or set field separator for unaligned query output
> > \t show only rows (currently off)
> > \echo [STRING] write string to standard output
> > \qecho [STRING] write string to query output stream (see \o)
> >
> > HTML Output
> > \H toggle HTML output mode (currently off)
> > \C [STRING] set table title, or unset if none
> > \T [STRING] set HTML <table> tag attributes, or unset if none
> > \pset NAME [VALUE] set table output option
> > (NAME := {format|border|expanded|fieldsep|null|recordsep|
> > tuples_only|title|tableattr|pager})
> >
> >
> > --------------------------------------------------------------------------
> -
> >
> > Harald Armin Massa wrote:
> > > > Sounds like a great idea --- a longer help version for psql. Yes,
> > > > please give it a try.
> > >
> > > Bruce,
> > >
> > > during ordering I found another "immediate" solution:
> > >
> > > in the Output
> > >
> > > \d TABLE describe table (or view, index, sequence)
> > >
> > > just add
> > >
> > > \d TABLE describe table (or view, index, sequence) add '+' for
> > > extended
> > >
> > >
> > > 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
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

--
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