SET/SHOW

Overview

The SET statement lets you set specific options while the SHOW statement helps you see the current values in Oxla.

The syntax for these functions is as follows:

SET <option> TO <value>;

For options that accept boolean values, <value> can be either ON or OFF, which correspond to TRUE or FALSE respectively

The available options that can be set and shown are:

extra_float_digits: by default, Oxla displays a limited number of digits, but you can set how many extra digits are displayed after the decimal point in floating-point numbers by using this option
application_name: sets a custom name for the application
timezone: determines the time zone used for date and time functions
client_min_messages: sets the message levels sent to the client (valid values are DEBUG5, DEBUG4, DEBUG3, DEBUG2, DEBUG1, LOG, NOTICE, WARNING and ERROR)
search_path: defines namespaces at which Oxla looks for tables
enable_fast_math: enables mathematical optimizations that trade precision for speed by utilizing faster, less accurate mathematical functions

To change the number of displayed digits for floating-point values, use the SET statement in a following way:

SET extra_float_digits TO 2;

SHOW extra_float_digits;

 extra_float_digits 
--------------------
 2

To display the current timezone setting, use the following query:

SHOW timezone;

 timezone 
----------
 Etc/UTC