SHOW(l)                                                   SHOW(l)

NAME
       SHOW - Shows run-time parameters for session

SYNOPSIS
       SHOW keyword

   INPUTS
       keyword
              Refer  to  SET  for  more  information on available
              arguments.

   OUTPUTS
       NOTICE: variable is value
              Message returned if successful.

       NOTICE: Unrecognized variable value
              Message returned if value does not exist.

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

DESCRIPTION
       SHOW will display the current configuration parameters for
       variable during a session.

       The session can be configured  using  SET  statement,  and
       values  can be restored to the defaults using RESET state-
       ment.  Parameters and values are case-insensitive.

   NOTES
       The SHOW is a Postgres language extension.

       Refer to SET/RESET to set/reset variable values.  See also
       SET TIME ZONE.

USAGE
       Show the current DateStyle setting:

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

       Show the current genetic optimizer (geqo) setting:

       SHOW GEQO;
       NOTICE:GEQO is ON

COMPATIBILITY
   SQL92
       There is no SHOW defined in SQL92.

SQL - Language Statements 15 August 1999                        1