show man page on aLinux

Man page or keyword search:  
man Server   7435 pages
apropos Keyword Search (all sections)
Output format
aLinux logo
[printable version]

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 session authorization identifier  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	  2005-11-05				SHOW()
[top]

List of man pages available for aLinux

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net