SHOW

Name

SHOW — Shows run-time parameters for session
SHOW keyword
  

Inputs

keyword

Refer to SET for more information on available variables.

Outputs

NOTICE: variable is value

Message returned if successful.

NOTICE: Unrecognized variable value

Message returned if variable does not exist.

NOTICE: Time zone is unknown

If the TZ or PGTZ environment variable is not set.

Description

SHOW will display the current setting of a run-time parameter during a session.

These variables can be set using the SET statement, and can be restored to the default values using the RESET statement. Parameters and values are case-insensitive.

Notes

See also SET and RESET to manipulate variable values.

Usage

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 is ON beginning with 11 relations
   

Compatibility

SQL92

There is no SHOW defined in SQL92.