Skip to content

SHOW

Show the current value of a configuration parameter or show the values for all parameters.

SHOW parameter | ALL

For example:

premdb=> show search_path;
   search_path    
-------------------
 public, allpremdb
(1 row)
premdb=# show yb_server_version;
 yb_server_version 
-------------------
 0.5.0
(1 row)

SHOW ALL includes a description of each parameter.

premdb=# show all;
               name                 |     setting     |                              description                              
-------------------------------------+-----------------+-----------------------------------------------------------------------
 application_name                    | ybsql           | Sets the application name to be reported in statistics and logs.
 client_encoding                     | UTF8            | Sets the client's character set encoding.
 DateStyle                           | ISO, MDY        | Sets the display format for date and time values.
 idle_in_transaction_session_timeout | 10min           | Sets the maximum allowed duration of any idling transaction.
 idle_session_timeout                | 1h              | Sets the maximum allowed session duration after any statement.
 lc_collate                          | C               | Shows the collation order locale.
 lc_ctype                            | C               | Shows the character classification and case conversion locale.
 lc_time                             | C               | Sets the locale for formatting date and time values.
...

Note that running show idle_session_timeout or show idle_in_transaction_session_timeout as a superuser will always return unlimited (0), which is the superuser's setting, not the default setting for the appliance.

The following parameters cannot be changed (by superusers or regular users):

  • lc_collate
  • lc_ctype
  • lc_time
  • server_encoding
  • yb_last_execid
  • yb_server_version
  • yb_server_version_num

Parent topic:SQL Commands