SHOW SQL - Language Statements SHOW Shows run-time parameters for session 1998-08-31 SHOW variable 1998-08-31 variable Refer to the SET statement for more information on available variables. 1998-08-31 NOTICE: variable is value SHOW VARIABLE Message returned if successfully. NOTICE: Unrecognized variable value Message returned if value does not exist. 1998-08-31 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. 1998-08-31 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 1998-08-31 There is no SET statement defined in SQL92.