SHOW

Name

SHOW  --  Displays the values of run-time variables.

Synopsis

SHOW name
  

Parameters

name

Use this parameter to provide the name of a run-time variable.

Results

ERROR: not a vaild option name: name

This error is displayed if the variable specified is not an existing parameter.

ERROR: permission denied

This error is displayed if you do not have the permissions neccessary to view this information.

NOTICE: Time zone is unknown

This message is displayed if the TZ or PGTZ environment variable is not set.

Description

Use SHOW to display the current settings for a specified run-time variable. The variables in question are specified using the SET command, or automatically determined during server startup.

Examples

The following example displays the current transaction isolation level.

booktown=# SHOW TRANSACTION ISOLATION LEVEL;
NOTICE:  TRANSACTION ISOLATION LEVEL is SERIALIZABLE
SHOW VARIABLE

The following example displays the current date formatting style.

 
booktown=# SHOW DATESTYLE;
NOTICE:  DateStyle is ISO with US (NonEuropean) conventions
SHOW VARIABLE