SHOW name
This error is displayed if the variable specified is not an existing parameter.
This error is displayed if you do not have the permissions neccessary to view this information.
This message is displayed if the TZ or PGTZ environment variable is not set.
Use SHOW to display the current settings for a specified run-time variable. The variables in question are specified using the SET command, or automatically determined during server startup.
The following example displays the current transaction isolation level.
booktown=# SHOW TRANSACTION ISOLATION LEVEL; NOTICE: TRANSACTION ISOLATION LEVEL is SERIALIZABLE SHOW VARIABLE
The following example displays the current date formatting style.
booktown=# SHOW DATESTYLE; NOTICE: DateStyle is ISO with US (NonEuropean) conventions SHOW VARIABLE