show

SHOW()				 SQL Commands			       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	post-
       gresql.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 [XRef to RUNTIME-
       CONFIG] for details.

PARAMETERS
       name   The name of a run-time parameter. Available parameters are doc-
	      umented  in  [XRef  to  RUNTIME-CONFIG] and on the SET [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  initdb
		     time.

	      LC_CTYPE
		     Shows  the database’s locale setting for character clas-
		     sification. 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 configurations parameters.

NOTES
       The  function current_setting produces equivalent output. See [XRef to
       FUNCTIONS-MISC].

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
       -------------------------------+---------------------------------------
	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
       SET [set(7)]



SQL - Language Statements	  2008-01-03			       SHOW()