SHOW

Name

SHOW — Shows run-time parameters for session
SHOW variable

Inputs

variable

Refer to the SET statement for more information on available variables.

Outputs

NOTICE: variable is value SHOW VARIABLE

Message returned if successfully.

NOTICE: Unrecognized variable value

Message returned if value does not exist.

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 statement. Parameters and values are case-insensitive.

Notes

The SHOW statement is a Postgres language extension.

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

If the TZ environment variable is not set the SHOW TIME ZONE statement gives the message: Time zone is unknown

Usage

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

   -- show Geqo;
   SHOW GEQO;
   NOTICE:GEQO is ON

Compatibility

SQL92

There is no SET statement defined in SQL92.