redhat man page for show

SHOW(7) 							   SQL Commands 							   SHOW(7)

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(7)] 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 post-
       gresql.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.

SQL - Language Statements					    2002-11-22								   SHOW(7)