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 the documentation
       for details.

PARAMETERS
       name   The name of a run-time parameter. Available parameters are docu-
	      mented  in  the  documentation 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 classi-
		     fication. At present, this parameter can be shown but not
		     set, because the setting is determined at initdb time.

	      IS_SUPERUSER
		     True if the current role has superuser privileges.

       ALL    Show the values of all configuration parameters,	with  descrip-
	      tions.

NOTES
       The  function current_setting produces equivalent output. See the docu-
       mentation.

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
       --------------------------------+--------------------------------+----------------------------------------------------------------------------------------------
	add_missing_from	       | off				| Automatically adds missing table references to FROM clauses.
	archive_command		       | unset				| WAL archiving command.
	australian_timezones	       | off				| Interprets ACST, CST, EST, and SAT as Australian time zones.
	   .
	   .
	   .
	work_mem		       | 1024				| Sets the maximum memory to be used for query workspaces.
	zero_damaged_pages	       | off				| Continues processing past damaged page headers.
       (146 rows)


COMPATIBILITY
       The SHOW command is a PostgreSQL extension.

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



SQL - Language Statements	  2010-12-14				SHOW()