Index for Section 5

Alphabetical listing for S

Bottom of page

SHOW(5)
NAME
  SHOW - show the value of a run-time parameter

SYNOPSIS
  SHOW name

  SHOW ALL

  INPUTS

  name The name of a run-time parameter. See SET [set(5)] for a list.

  ALL  Show all current session parameters.

DESCRIPTION
  SHOW will display the current setting of a run-time parameter. These
  variables can be set using the SET statement, by editing the
  postgresql.conf, through the PGOPTIONS environmental variable, or through a
  command-line flag when starting the postmaster.

  Even with autocommit set to off, SHOW does not start a new transaction
  block. See the autocommit section of the Administrator's Guide for details.

DIAGNOSTICS
  ERROR: Option 'name'
       Message returned if name does not stand for an existing parameter.

EXAMPLES
  Show the current DateStyle setting:

  SHOW DateStyle;
		 DateStyle
  ---------------------------------------
   ISO with US (NonEuropean) conventions
  (1 row)

  Show the current genetic optimizer (geqo) setting:

  SHOW GEQO;
   geqo
  ------
   on
  (1 row)

  Show all settings:

  SHOW ALL;
	       name		 |		  setting
  -------------------------------+---------------------------------------
   australian_timezones		 | off
   authentication_timeout	 | 60
   checkpoint_segments		 | 3
      .
      .
      .
   wal_debug			 | 0
   wal_sync_method		 | fdatasync
  (94 rows)

COMPATIBILITY
  The SHOW command is a PostgreSQL extension.

SEE ALSO
  The function current_setting produces equivalent output. See Miscellaneous
  Functions in the PostgreSQL User's Guide.

Index for Section 5

Alphabetical listing for S

Top of page