show man page on UnixWare

Man page or keyword search:  
man Server   3616 pages
apropos Keyword Search (all sections)
Output format
UnixWare 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 postgres. See in the documentation
       for details.

PARAMETERS
       name   The name of a run-time parameter. Available parameters are docu‐
	      mented in in the documentation and on the SET [set(5)] 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 in the
       documentation.

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.
	   .
	   .
	   .
	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(5)], RESET [reset(l)]

SQL - Language Statements	  2008-01-03				SHOW()
[top]
                             _         _         _ 
                            | |       | |       | |     
                            | |       | |       | |     
                         __ | | __ __ | | __ __ | | __  
                         \ \| |/ / \ \| |/ / \ \| |/ /  
                          \ \ / /   \ \ / /   \ \ / /   
                           \   /     \   /     \   /    
                            \_/       \_/       \_/ 
More information is available in HTML format for server UnixWare

List of man pages available for UnixWare

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