SHOW variable
Refer to the SET statement for more information on available variables.
Message returned if successfully.
Message returned if value does not exist.
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 statement is a Postgres language extension.
Refer to the SET/RESET statements to set/reset variable values. See also the SET TIME ZONE statement.
If the TZ environment variable is not set the SHOW TIME ZONE statement gives the message: Time zone is unknown
-- show DateStyle; SHOW DateStyle; NOTICE:DateStyle is Postgres with US (NonEuropean) conventions -- show Geqo; SHOW GEQO; NOTICE:GEQO is ON
There is no SET statement defined in SQL92.