SHOW - Shows run-time parameters


SYNOPSIS

       SHOW name

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


DESCRIPTION

       SHOW will display the current setting of a run-time param­
       eter.  These  variables can be set using the SET statement
       or are determined at server start.


DIAGNOSTICS

       ERROR: not a valid option name: name
              Message returned if variable does not stand for  an
              existing parameter.

       ERROR: permission denied
              You  must  be a superuser to be allowed to see cer­
              tain settings.

       NOTICE: Time zone is unknown
              If the TZ or PGTZ environment variable is not  set.


EXAMPLES

       Show the current DateStyle setting:

       SHOW DateStyle;
       NOTICE:  DateStyle is ISO with US (NonEuropean) conventions

       Show the current genetic optimizer (geqo) setting:

       SHOW GEQO;
       NOTICE:  geqo = true


COMPATIBILITY

       The SHOW command is a Postgres extension.


Man(1) output converted with man2html