aboutsummaryrefslogtreecommitdiff
path: root/src/bin/psql/help.c
Commit message (Collapse)AuthorAge
...
* DDL support for collationsPeter Eisentraut2011-02-12
| | | | | | | | | | | | | - collowner field - CREATE COLLATION - ALTER COLLATION - DROP COLLATION - COMMENT ON COLLATION - integration with extensions - pg_dump support for the above - dependency management - psql tab completion - psql \dO command
* Core support for "extensions", which are packages of SQL objects.Tom Lane2011-02-08
| | | | | | | | | | | | | This patch adds the server infrastructure to support extensions. There is still one significant loose end, namely how to make it play nice with pg_upgrade, so I am not yet committing the changes that would make all the contrib modules depend on this feature. In passing, fix a disturbingly large amount of breakage in AlterObjectNamespace() and callers. Dimitri Fontaine, reviewed by Anssi Kääriäinen, Itagaki Takahiro, Tom Lane, and numerous others
* Update psql's \copyright to match the text we have in the COPYRIGHT file.Heikki Linnakangas2011-01-27
|
* Document the "S" option for psql's \dn command in the psql helpPeter Eisentraut2011-01-25
| | | | | This option was recently introduced, but the documentation in help.c was not updated.
* Add new psql command \dL to list languages.Robert Haas2011-01-20
| | | | | Original patch by Fernando Ike, revived by Josh Kuperschmidt, reviewed by Andreas Karlsson, and in earlier versions by Tom Lane and Peter Eisentraut.
* Basic foreign table support.Robert Haas2011-01-01
| | | | | | | | | | | Foreign tables are a core component of SQL/MED. This commit does not provide a working SQL/MED infrastructure, because foreign tables cannot yet be queried. Support for foreign table scans will need to be added in a future patch. However, this patch creates the necessary system catalog structure, syntax support, and support for ancillary operations such as COMMENT and SECURITY LABEL. Shigeru Hanada, heavily revised by Robert Haas
* Stamp copyrights for year 2011.Bruce Momjian2011-01-01
|
* Make \? output of \dg and \du the samePeter Eisentraut2010-10-28
| | | | | | | The previous wording might have suggested that \du only showed login roles and \dg only group roles, but that is no longer the case. proposed by Josh Kupershmidt
* Remove cvs keywords from all files.Magnus Hagander2010-09-20
|
* Add a \sf (show function) command to psql, for those times when you need toTom Lane2010-08-14
| | | | | | look at a function but don't wish to fire up an editor. Pavel Stehule, reviewed by Jan Urbanski
* Clean up failure to use ClosePager() where appropriate in help.c.Tom Lane2010-08-13
| | | | Also prevent possible repeat opening of pager in helpSQL().
* Extend psql's \e and \ef commands so that a line number can be specified,Tom Lane2010-08-12
| | | | | | | | | | | | | | | | | | and the editor's cursor will be initially placed on that line. In \e the lines are counted with respect to the query buffer, while in \ef they are counted with line 1 = first line of function body. These choices are useful for positioning the cursor on the line of a previously-reported error. To avoid assumptions about what switch the user's editor takes for this purpose, invent a new psql variable EDITOR_LINENUMBER_SWITCH with (at present) no default value. One incompatibility from previous behavior is that "\e 1234" will now take "1234" as a line number not a file name. There are at least two ways to select a numerically-named file if you really want to. Pavel Stehule, reviewed by Jan Urbanski, with further editing by Robert Haas and Tom Lane
* Add \conninfo command to psql, to show current connection info.Robert Haas2010-07-20
| | | | David Christensen. Reviewed by Steve Singer. Some further changes by me.
* Fix psql help: \da+ is same as \da, but \daS is not.Robert Haas2010-05-26
| | | | Noted by Stephen Frost.
* Work around a subtle portability problem in use of printf %s format.Tom Lane2010-05-08
| | | | | | | | | | | | | Depending on which spec you read, field widths and precisions in %s may be counted either in bytes or characters. Our code was assuming bytes, which is wrong at least for glibc's implementation, and in any case libc might have a different idea of the prevailing encoding than we do. Hence, for portable results we must avoid using anything more complex than just "%s" unless the string to be printed is known to be all-ASCII. This patch fixes the cases I could find, including the psql formatting failure reported by Hernan Gonzalez. In HEAD only, I also added comments to some places where it appears safe to continue using "%.*s".
* Revert patch for --psqlrc=FILENAME in psql.Magnus Hagander2010-03-07
|
* Add --psqlrc=FILENAME parameter to psql, to process an explicitly namedMagnus Hagander2010-03-06
| | | | file instead of ~/.psqlrc on startup.
* Update copyright for the year 2010.Bruce Momjian2010-01-02
|
* Add the new psql command \drds to the psql docs, help and tab completion.Alvaro Herrera2009-10-08
| | | | | I also thank Bernd Helmle for the documentation help on the previous settings patch, which I forgot on the commit message.
* Create an ALTER DEFAULT PRIVILEGES command, which allows users to adjustTom Lane2009-10-05
| | | | | | | | | | | the privileges that will be applied to subsequently-created objects. Such adjustments are always per owning role, and can be restricted to objects created in particular schemas too. A notable benefit is that users can override the traditional default privilege settings, eg, the PUBLIC EXECUTE privilege traditionally granted by default for functions. Petr Jelinek
* Easier to translate psql helpPeter Eisentraut2009-09-18
| | | | | | | | | | | Instead of requiring translators to translate the entire SQL command synopses, change create_help.pl to only require them to translate the placeholders, and paste those into the synopsis using a printf mechanism. Make some small updates to the markup to make it easier to parse. Note: This causes msgmerge of gettext 0.17 to segfault. You will need the patch from https://savannah.gnu.org/bugs/?27474 to make it work. msgmerge usually only runs on babel.postgresql.org, however.
* Document \dg+ and \du+Peter Eisentraut2009-07-24
| | | | | | | | The fact that \dg and \du take the + option was missing in the documentation. backpatched to 8.4 Author: Andreas Wenk <a.wenk@netzmeister-st-pauli.de>
* 8.4 pgindent run, with new combined Linux/FreeBSD/MinGW typedef listBruce Momjian2009-06-11
| | | | provided by Andrew.
* Use brackets in psql \df \? help.Bruce Momjian2009-04-22
|
* Merge psql \df options into a single \? line, and update docs.Bruce Momjian2009-04-21
|
* Add agg/normal/trigger/window flags for psql \df and in \df output.Bruce Momjian2009-04-21
| | | | David Fetter
* Message improvementPeter Eisentraut2009-04-11
|
* Add missing help output for \ef option. Andrew GierthTom Lane2009-04-03
|
* Update line count for \? output (obtained from wc -l)Peter Eisentraut2009-03-25
|
* In the \? output, align the columns consistently.Peter Eisentraut2009-03-25
|
* Fix my typoPeter Eisentraut2009-03-24
|
* Add the long options to the psql --help display, where they were curiouslyPeter Eisentraut2009-02-27
| | | | | | | | missing. Since this touches most lines of the help output, also change the mix of puts and printf calls to printf everywhere, for easier code editing and reviewing.
* Add a -w/--no-password option that prevents all password prompts to allPeter Eisentraut2009-02-26
| | | | | | programs that have a -W/--password option. In passing, remove the ancient PSQL_ALWAYS_GET_PASSWORDS compile option.
* Sort the output of --help mostly alphabetical, make it align better, makePeter Eisentraut2009-02-25
| | | | help of pg_dump and pg_dumpall more similar.
* Removeduplicate \dd psql help mention.Bruce Momjian2009-01-07
|
* Add spaces around psql \d* columns, per idea from Joshua Drake.Bruce Momjian2009-01-07
|
* Improve \z psql \? help display.Bruce Momjian2009-01-06
|
* Add documentation for new \d*S* patch, and clean up some of the docs.Bruce Momjian2009-01-06
| | | | Fix \do and trigger display for the patch too.
* This makes all the \dX commands (most importantly to most: \df) workBruce Momjian2009-01-06
| | | | | | like \dt does, in that it requires a \dXS to see system items. Greg Sabino Mullane
* Update copyright for 2009.Bruce Momjian2009-01-01
|
* SQL/MED catalog manipulation facilitiesPeter Eisentraut2008-12-19
| | | | | | | | This doesn't do any remote or external things yet, but it gives modules like plproxy and dblink a standardized and future-proof system for managing their connection information. Martin Pihlak and Peter Eisentraut
* Improve psql's \dC command to take a pattern parameter. Casts are shownTom Lane2008-11-06
| | | | | if their source or target types match the pattern (using the same definition of "match" as \dT does). Per recent discussion.
* Document that \t and \x are now settable.Alvaro Herrera2008-08-29
|
* Update "help" output to reflect that \timing now takes an optional on/offHeikki Linnakangas2008-06-11
| | | | argument.
* Update psql startup banner to be shorter, suggest "help" for help.Bruce Momjian2008-05-16
| | | | | | | | | | Add a few "help" entries. Move \g help entry into "General". Update psql version mismatch warning text. Joshua D. Drake
* Reorgnize psql \? help output, to reduce the size of the "General"Bruce Momjian2008-05-14
| | | | heading at the top; broken into more sections now.
* Have psql command 'help' suggest the use of \?, updated version.Bruce Momjian2008-04-04
| | | | Greg Sabino Mullane
* Allow 'help' in psql to show \? help, for novice assistance.Bruce Momjian2008-04-04
| | | | Greg Sabino Mullane
* Improve description of \du and \dg, per suggestion fromTom Lane2008-03-29
| | | | Harald Armin Massa.
* Include \password in the psql help.Magnus Hagander2008-03-26
| | | | | While at it, change the order of the documented options to be alphabetically again.
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-05 21:02:24 +0000