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

SHOW

Name

SHOW — Shows run-time parameters for session
SHOW variable
  

Inputs

variable

Refer to SET for more information on available variables.

Outputs

NOTICE: ">variabE> is value SHOW VARIABLE

Message returned if successfully.

NOTICE: Unrecognized variable value

Message returned if value does not exist.

NOTICE: Time zone is unknown SHOW VARIABLE

If the TZ 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 statement. 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 DateStyle;
SHOW DateStyle;
NOTICE:DateStyle is Postgres with US (NonEuropean) conventions

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

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