SHOW(7) 							   SQL Commands 							   SHOW(7)

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 postgres server. See in the documentation for details.

PARAMETERS

       name   The  name  of  a	run-time  parameter. Available parameters are documented in 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 database creation 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 database creation time.

	      IS_SUPERUSER
		     True if the current role has superuser privileges.

       ALL    Show the values of all configuration parameters, with descriptions.

NOTES

       The  function  current_setting  produces  equivalent output; see in the documentation.  Also, the pg_settings system view produces the same
       information.

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.
	allow_system_table_mods        | off				| Allows modifications of the structure of system tables.
	   .
	   .
	   .
	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(7)]

SQL - Language Statements					    2010-05-14								   SHOW(7)