phpMan > info > SHOW(7)

SHOW(7)                 PostgreSQL 14.23 Documentation                 SHOW(7)

NAME
       SHOW - show the value of a run-time parameter

SYNOPSIS
       SHOW name
       SHOW ALL

DESCRIPTION
       SHOW will display the current setting of run-time parameters. These
       variables can be set using the SET statement, by editing the
       postgresql.conf configuration file, through the PGOPTIONS environmental
       variable (when using libpq or a libpq-based application), or through
       command-line flags when starting the postgres server. See Chapter 20
       for details.

PARAMETERS
       name
           The name of a run-time parameter. Available parameters are
           documented in Chapter 20 and on the SET(7) reference page. In
           addition, there are a few parameters that can be shown but not set:

           SERVER_VERSION
               Shows the server's version number.

           SERVER_ENCODING
               Shows the server-side character set encoding. At present, this
               parameter can be shown but not set, because the encoding is
               determined at database creation time.

           LC_COLLATE
               Shows the database's locale setting for collation (text
               ordering). At present, this parameter can be shown but not set,
               because the setting is determined at database creation time.

           LC_CTYPE
               Shows the database's locale setting for character
               classification. At present, this parameter can be shown but not
               set, because the setting is determined at database creation
               time.

           IS_SUPERUSER
               True if the current role has superuser privileges.

       ALL
           Show the values of all configuration parameters, with descriptions.

NOTES
       The function current_setting produces equivalent output; see
       Section 9.27.1. Also, the pg_settings system view produces the same
       information.

EXAMPLES
       Show the current setting of the parameter DateStyle:

           SHOW DateStyle;
            DateStyle
            ISO, MDY
           (1 row)

       Show the current setting of the parameter geqo:

           SHOW geqo;
            geqo
            on
           (1 row)

       Show all settings:

           SHOW ALL;
                       name         | setting |                description
           -------------------------+---------+-------------------------------------------------
            allow_system_table_mods | off     | Allows modifications of the structure of ...
               .
               .
               .
            xmloption               | content | Sets whether XML data in implicit parsing ...
            zero_damaged_pages      | off     | Continues processing past damaged page headers.
           (196 rows)

COMPATIBILITY
       The SHOW command is a PostgreSQL extension.

SEE ALSO
       SET(7), RESET(7)

PostgreSQL 14.23                     2026                              SHOW(7)
SHOW(1mh)                                                            SHOW(1mh)

NAME
       show - display nmh messages

SYNOPSIS
       show [-help] [-version] [+folder] [msgs] [-draft] [-showproc program]
            [-showmimeproc program] [-header | -noheader] [-checkmime |
            -nocheckmime] [-concat | -noconcat] [switches for showproc or
            showmimeproc]

DESCRIPTION
       show lists each of the specified messages to the standard output (typi-
       cally, the terminal).

       By  default, text (non-MIME) messages are filtered and displayed by the
       nmh command mhl.  This command will display text messages  in  a  nice,
       uniform format.  It also allows you to configure the format of the dis-
       played messages and which headers fields are  shown.   See  the  mhl(1)
       manual  page  for  the details about this command.  This default can be
       changed by defining the showproc profile component.  Any  switches  not
       recognized  by show, as well as -header and -noheader, are passed along
       to that program.  To override the default and the showproc profile com-
       ponent,  use the -showproc program switch.  For example, -showproc more
       will cause the more program to list the messages with no  reformatting.
       Normally,  this  program  is  specified  as  the showproc in the user's
       .mh_profile, rather than using a command line switch.

       By default, non-text messages (MIME messages with multi-media contents)
       are  processed  and  displayed  by  the  nmh  command  mhshow.  See the
       mhshow(1) manual page for details about this command.  This default can
       changed  by  defining the showmimeproc profile component.  Any switches
       not recognized by show are passed along to that program.   To  override
       this default and the showmimeproc profile component, use the -showmime-
       proc program switch.

       Note that in some cases, show may invoke the showmimeproc even for tex-
       tual  contents.   This  will  happen  for  text messages that specify a
       transfer encoding (such as MIME quoted-printable or base64) or  specify
       a  character  set  that show doesn't believe can be displayed natively.
       The appropriate locale(1) environment variables should be  set  to  the
       terminal's  native character set to avoid gratuitous invocations of the
       showmimeproc.  See the locale(1) man page for details about these envi-
       ronment variables.

       The option -checkmime (set by default) instructs show to test if any of
       the messages to be displayed are non-text (MIME) messages.  If any  are
       non-text, they are displayed by the program showmimeproc, else they are
       displayed by the program showproc.  The  option  -nocheckmime  disables
       this test and instructs show to use showproc, regardless of whether any
       of the messages are non-text (MIME) messages.

       The -noshowproc switch will disable any formatting or  paging  of  mes-
       sages.   It  is  equivalent to -nocheckmime -showproc cat.  It is still
       accepted, but should be considered (somewhat) obsolete.

       The -header switch tells show to display a one-line description of  the
       message being shown.  This description includes the folder and the mes-
       sage number.

       By default show will concatenate all content under one pager.   If  you
       want  each  part  to displayed separately, you can override the default
       behavior with -noconcat.

       If no `msgs' are specified, the current message is used.   Although  it
       depends  on the specific showproc or showmimeproc, in the default setup
       when more than one message is specified, you will  be  prompted  for  a
       <RETURN>  prior to listing each message.  Each message will be listed a
       page at a time, and when the end of page is reached, the  program  will
       wait  for  a  <SPACE>  or  <RETURN>.  If a <RETURN> is entered, it will
       print the next line, whereas <SPACE> will print the next screenful.

       If the standard output is not a terminal, no queries are made, and each
       file is listed with a one-line header and two lines of separation.

       "show -draft" will list the file <mh-dir>/draft if it exists.

       If  the  profile entry "Unseen-Sequence" is present and non-empty, then
       show will remove each of the messages shown from each sequence named by
       the profile entry.

FILES
       $HOME/.mh_profile          The user profile

PROFILE COMPONENTS
       Path:                To determine the user's nmh directory
       Current-Folder:      To find the default current folder
       Unseen-Sequence:     To name sequences denoting unseen messages
       showproc:            Program to show text (non-MIME) messages
       showmimeproc:        Program to show non-text (MIME) messages

SEE ALSO
       mhl(1), mhshow(1), next(1), prev(1), scan(1)

DEFAULTS
       `+folder' defaults to the current folder
       `msgs' defaults to cur
       `-checkmime'
       `-header'
       `-concat'

CONTEXT
       If a folder is given, it will become the current folder.  The last mes-
       sage selected will become the current message.

BUGS
       The -header switch doesn't work when `msgs' expands to  more  than  one
       message.  If the showproc is mhl, then this problem can be circumvented
       by referencing the "messagename" field in the mhl format file.

       show updates the user's context before showing the message.  Hence show
       will  mark  messages  as  seen  prior to the user actually seeing them.
       This is generally not a problem, unless the user relies on the "unseen"
       messages  mechanism,  and  interrupts show while it is showing "unseen"
       messages.

       If your showproc is mhl (the default), then show uses a  built-in  mhl:
       it  does  not  actually run the mhl program.  Hence, if you define your
       own showproc, don't call it mhl since show won't run it.

       If your showproc is the pager more, then  avoid  running  show  in  the
       background  with  only its standard output piped to another process, as
       in

            show | imprint &

       Due to a bug in more, show will go into a "tty input" state.  To  avoid
       this problem, re-direct show's diagnostic output as well.  For users of
       csh:

            show |& imprint &

       For users of sh:

            show 2>&1 | imprint &

nmh-1.7.1                         2016-03-24                         SHOW(1mh)