👤
Home Man
Search
Today's Posts
Register

Linux & Unix Commands - Search Man Pages
Man Page or Keyword Search:
Select Section of Man Page:
Select Man Page Repository:

RedHat 9 (Linux i386) - man page for show (redhat section 7)

SHOW(7) 				   SQL Commands 				  SHOW(7)

NAME
       SHOW - show the value of a run-time parameter

SYNOPSIS
       SHOW name

       SHOW ALL

   INPUTS
       name   The name of a run-time parameter. See SET [set(7)] for a list.

       ALL    Show all current session parameters.

DESCRIPTION
       SHOW  will display the current setting of a run-time parameter. These variables can be set
       using the SET statement, by editing the postgresql.conf, through the PGOPTIONS environmen-
       tal variable, or through a command-line flag when starting the postmaster.

       Even  with  autocommit  set  to	off, SHOW does not start a new transaction block. See the
       autocommit section of the Administrator's Guide for details.

DIAGNOSTICS
       ERROR: Option 'name'
	      Message returned if name does not stand for an existing parameter.

EXAMPLES
       Show the current DateStyle setting:

       SHOW DateStyle;
		      DateStyle
       ---------------------------------------
	ISO with US (NonEuropean) conventions
       (1 row)

       Show the current genetic optimizer (geqo) setting:

       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
       The function current_setting produces equivalent output. See  Miscellaneous  Functions  in
       the PostgreSQL User's Guide.

SQL - Language Statements		    2002-11-22					  SHOW(7)


All times are GMT -4. The time now is 12:12 AM.

Unix & Linux Forums Content Copyrightę1993-2018. All Rights Reserved.
×
UNIX.COM Login
Username:
Password:  
Show Password