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.