Refer to SET for more information on available variables.
Message returned if successful.
Message returned if variable does not exist.
If the TZ or PGTZ environment variable is not set.
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.
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
There is no SHOW defined in SQL92.