SET/SHOW

Overview

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

Syntax

The syntax for these functions is as follows:

• SET
• SHOW

SET <option> TO <value>;

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

SET <option> TO <value>;

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

SHOW <option>;

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

Examples

SET Statement

• Extra_float_digits
• Client_min_messages
• Enable_fast_math

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 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 change the client message, use the SET statement as follows:

SET client_min_messages TO 'WARNING';

SHOW client_min_messages;

 client_min_messages 
---------------------
 warning

To change the mode of the fast math option, use the SET statement like this:

SET oxla.enable_fast_math = ON;

SHOW oxla.enable_fast_math;

 oxla_enable_fast_math 
-----------------------
 1
(1 row)

SHOW Statement

• Timezone
• Search_path
• Enable_fast_math

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

SHOW timezone;

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

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

SHOW timezone;

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

To display the current search path, run the query below:

SHOW search_path;

 search_path 
-------------
 public

To check the status of the fast math option, use the following method:

SHOW oxla.enable_fast_math;

 oxla_enable_fast_math 
-----------------------
 0
(1 row)