GNU/Linux |
RedHat 6.2(Zoot) |
|
![]() |
show(l) |
![]() |
SHOW − Shows run-time parameters for session
SHOW keyword
INPUTS
keyword
Refer to SET for more information on available arguments.
OUTPUTS
NOTICE: variable is value
Message returned if successful.
NOTICE: Unrecognized variable value
Message returned if value does not exist.
NOTICE: Time zone is unknown
If the TZ or PGTZ environment variable is not set.
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.
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
SQL92
There is no SHOW defined in SQL92.
![]() |
show(l) | ![]() |