SHOW

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 SHOW VARIABLE

Message returned if successful.

NOTICE: Unrecognized variable value

Message returned if value does not exist.

NOTICE: Time zone is unknown SHOW VARIABLE

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

SHOW is a Postgres language extension.

Refer to SET/RESET to set/reset variable values.

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.