SHOW keyword
Refer to SET for more information on available arguments.
Message returned if successful.
Message returned if value does not exist.
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.
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
There is no SHOW defined in SQL92.