SET
statement lets you set specific options while the SHOW
statement helps you see the current values in Oxla.
<value>
can be either ON
or OFF
, which correspond to TRUE
or FALSE
respectivelyextra_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 optionapplication_name
: sets a custom name for the applicationtimezone
: determines the time zone used for date and time functionsclient_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 tablesenable_fast_math
: enables mathematical optimizations that trade precision for speed by utilizing faster, less accurate mathematical functionsSET
statement in a following way: