Index for Section 5

Alphabetical listing for S

Bottom of page

SHOW()
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 postmaster. See the documentation for
  details.

PARAMETERS
  name The name of a run-time parameter. Available parameters are documented
       in the documentation and on the SET [set(5)] 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 initdb 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 initdb time.

       IS_SUPERUSER
	 True if the current session authorization identifier has superuser
	 privileges.

  ALL  Show the values of all configuration parameters.

NOTES
  The function current_setting produces equivalent output. See the
  documentation.

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
  --------------------------------+----------------------------------------------
   add_missing_from		  | on
   archive_command		  | unset
   australian_timezones		  | off
      .
      .
      .
   work_mem			  | 1024
   zero_damaged_pages		  | off
  (140 rows)

COMPATIBILITY
  The SHOW command is a PostgreSQL extension.

SEE ALSO
  SET [set(5)], RESET [reset(l)]

Index for Section 5

Alphabetical listing for S

Top of page