Re: psql \? help display
От | Bruce Momjian |
---|---|
Тема | Re: psql \? help display |
Дата | |
Msg-id | 200805131532.m4DFWJ514875@momjian.us обсуждение исходный текст |
Ответ на | Re: psql \? help display (Alvaro Herrera <alvherre@commandprompt.com>) |
Ответы |
Re: psql \? help display
(Shane Ambler <pgsql@Sheeky.Biz>)
|
Список | pgsql-hackers |
Alvaro Herrera wrote: > Bruce Momjian wrote: > > I promised to review our psql \? output to see if I could improve it, > > particularly the "General" section at the top. Below are the results. > > > > Are the new sections ideal, and in the best ordering? Should \copyright > > be kept in "General" at the top? Should \? be listed? > > Why do we have a section named "Copy, Large Objects"? It would seem to > make sense to put the LO stuff on its own section. OK, new version attached. I moved \copy into "External" and relabled the section as just "Large Object" (singular?). > > I also pulled up some descriptive text that caused the options to have > > blank lines between them. > > It was like that to keep the alignment of descriptions. It's a > judgement call of course, but personally I think the other way was > better. Yea, I looked at that and though the description on a new line was clearer it was harder to see the options in one glance. Lack of line breaks now makes the sections easier to identify. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + General \copyright show PostgreSQL usage and distribution terms \h [NAME] help on syntax of SQL commands, * for all commands \q quit psql 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 \echo [STRING] write string to standard output \i FILE execute commands from file \o [FILE] send all query results to file or |pipe \qecho [STRING] write string to query output stream (see \o) 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 \db [PATTERN] list tablespaces (add "+" for more detail) \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) \dF [PATTERN] list text search configurations (add "+" for more detail) \dFd [PATTERN] list text search dictionaries (add "+" for more detail) \dFt [PATTERN] list text search templates \dFp [PATTERN] list text search parsers (add "+" for more detail) \dg [PATTERN] list roles (groups) \dn [PATTERN] list schemas (add "+" for more detail) \do [NAME] list operators \dl list large objects, same as \lo_list \dp [PATTERN] list table, view, and sequence access privileges \dT [PATTERN] list data types (add "+" for more detail) \du [PATTERN] list roles (users) \l list all databases (add "+" for more detail) \z [PATTERN] list table, view, and sequence access privileges (same as \dp) Formatting \a toggle between unaligned and aligned output mode \C [STRING] set table title, or unset if none \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|footer|null| numericlocale|recordsep|tuples_only|title|tableattr|pager}) \t show only rows (currently off) \T [STRING] set HTML <table> tag attributes, or unset if none \x toggle expanded output (currently off) Connection \c[onnect] [DBNAME|- USER|- HOST|- PORT|-] connect to new database (currently "test") \encoding [ENCODING] show or set client encoding \password [USERNAME] securely change the password for a user External \cd [DIR] change the current working directory \copy ... perform SQL COPY with data stream to the client host \timing toggle timing of commands (currently off) \! [COMMAND] execute command in shell or start interactive shell Variable \prompt [TEXT] NAME prompt user to set internal variable \set [NAME [VALUE]] set internal variable, or list all if no parameters \unset NAME unset (delete) internal variable Large Object \lo_export LOBOID FILE \lo_import FILE [COMMENT] \lo_list \lo_unlink LOBOID large object operations
В списке pgsql-hackers по дате отправления: