diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2014-01-16 15:29:18 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2014-01-16 15:29:33 -0500 |
| commit | 515d2c596c1b6b95d020d14edaab0d233d5d9ea9 (patch) | |
| tree | b880894afd6133ab03c52f8f665c8521f73e9c4a /doc/src | |
| parent | 3291301385ee5e9ca38d70a68b93ce31cc2674ac (diff) | |
| download | postgresql-515d2c596c1b6b95d020d14edaab0d233d5d9ea9.tar.gz postgresql-515d2c596c1b6b95d020d14edaab0d233d5d9ea9.zip | |
Add display of oprcode (the underlying function's name) to psql's \do+.
The + modifier of \do didn't use to do anything, but now it adds an oprcode
column. This is useful both as an additional form of documentation of what
the operator does, and to save a step when finding out properties of the
underlying function.
Marko Tiikkaja, reviewed by Rushabh Lathia, adjusted a bit by me
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/psql-ref.sgml | 18 |
1 files changed, 11 insertions, 7 deletions
diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index c666f714c3b..7ed20e4dd9a 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -1199,12 +1199,13 @@ testdb=> <literal>n</>, <literal>t</>, or <literal>w</> to the command. If <replaceable class="parameter">pattern</replaceable> is specified, only - functions whose names match the pattern are shown. If the - form <literal>\df+</literal> is used, additional information - about each function, including security, volatility, language, source - code and description, is shown. By default, only user-created + functions whose names match the pattern are shown. + By default, only user-created objects are shown; supply a pattern or the <literal>S</literal> modifier to include system objects. + If the form <literal>\df+</literal> is used, additional information + about each function is shown, including security classification, + volatility, owner, language, source code and description. </para> <tip> @@ -1337,15 +1338,18 @@ testdb=> <varlistentry> - <term><literal>\do[S] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\do[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> - Lists operators with their operand and return types. + Lists operators with their operand and result types. If <replaceable class="parameter">pattern</replaceable> is specified, only operators whose names match the pattern are listed. - By default, only user-created objects are shown; supply a + By default, only user-created objects are shown; supply a pattern or the <literal>S</literal> modifier to include system objects. + If <literal>+</literal> is appended to the command name, + additional information about each operator is shown, currently just + the name of the underlying function. </para> </listitem> </varlistentry> |