Re: psql 7.2.1: \d (alone) missing from \? - Mailing list pgsql-bugs
From | Bruce Momjian |
---|---|
Subject | Re: psql 7.2.1: \d (alone) missing from \? |
Date | |
Msg-id | 200206282325.g5SNPb414424@candle.pha.pa.us Whole thread Raw |
In response to | psql 7.2.1: \d (alone) missing from \? (Jay Berkenbilt <ejb@ql.org>) |
List | pgsql-bugs |
Oh, then the cleanup of putting [NAME] in brackets was done post-7.2.X. I remember that now, yes. Fix will be in 7.3. --------------------------------------------------------------------------- Jay Berkenbilt wrote: > > > Jay Berkenbilt wrote: > > > > > > This problem is so simple, the subject pretty much says it all. For > > > the sake of completeness, I'm running PostgreSQL 7.2.1 as supplied by > > > RedHat in their 7.3 release for i386. This bug report pertains only > > > to the psql front end. > > > > > > The command > > > > > > \d > > > > > > all by itself (with no arguments) lists all relations along with the > > > type and owner. This fact is, however, not mentioned in the help > > > message you get with \?, which lists loads of other things you can > > > with \d but forgets to mention \d all by itself. > > > > I see it in psql 7.2.1 with \?: > > > > \d [NAME] describe table (or view, index, sequence) > > > > Don't you have that line? > > No. I have > > \d TABLE describe table (or view, index, sequence) > > but it gives no indication that TABLE is optional or of what happens > if you omit it. Here's the output of my \?. > > ----------- > > \a toggle between unaligned and aligned output mode > \c[onnect] [DBNAME|- [USER]] > connect to new database (currently "acb2002") > \C TITLE set table title > \cd [DIRNAME] change the current working directory > \copy ... perform SQL COPY with data stream to the client host > \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 > \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 > \e FILENAME edit the current query buffer or file with external editor > \echo TEXT write text to standard output > \encoding ENCODING set client encoding > \f STRING set field separator > \g FILENAME send SQL command to server (and write results to file or |pipe) > \h NAME help on syntax of SQL commands, * for all commands > \H toggle HTML output mode (currently off) > \i FILENAME execute commands from file > \l list all databases > \lo_export, \lo_import, \lo_list, \lo_unlink > large object operations > \o FILENAME send all query results to file or |pipe > \p show the content of the current query buffer > \pset VAR set table output option (VAR := {format|border|expanded| > fieldsep|null|recordsep|tuples_only|title|tableattr|pager}) > \q quit psql > \qecho TEXT write text to query output stream (see \o) > \r reset (clear) the query buffer > \s FILENAME print history or save it to file > \set NAME VALUE set internal variable > \t show only rows (currently off) > \T TEXT set HTML table tag attributes > \unset NAME unset (delete) internal variable > \w FILENAME write current query buffer to file > \x toggle expanded output (currently off) > \z list table access privileges > \! [COMMAND] execute command in shell or start interactive shell > > ----------- > > -- > Jay Berkenbilt <ejb@ql.org> > http://www.ql.org/q/ > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
pgsql-bugs by date: