This page in other versions: Unsupported versions: 6.4 / 6.5 / 7.0

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.

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

Privacy Policy | About PostgreSQL
Copyright © 1996-2016 The PostgreSQL Global Development Group