The name of a run-time parameter. See SET for a list.
Show all current session parameters.
SHOW will display the current setting of a run-time parameter. These variables can be set using the SET statement or are determined at server start.
Message returned if variable does not stand for an existing parameter.
You must be a superuser to be allowed to see certain settings.
If the TZ or PGTZ environment variable is not set.
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
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.