Refer to SET for more information on available variables.
Message returned if successfully.
Message returned if value does not exist.
If the TZ 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 DateStyle; SHOW DateStyle; NOTICE:DateStyle is Postgres with US (NonEuropean) conventions -- show Geqo; SHOW GEQO; NOTICE:GEQO is ON
There is no SET defined in SQL92.
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.