Cloud

SET and SHOW

The SET statement configures session options. The SHOW statement displays their current values.

Syntax

SET statement:

SET <option> TO <value>;

The SET statement accepts both TO and = as the assignment operator.

For options that accept boolean values, <value> can be ON (true) or OFF (false).

SHOW statement:

SHOW <option>;

Available options:

extra_float_digits: Number of extra digits displayed after the decimal point in floating-point numbers.
application_name: Custom name for the application.
timezone: Time zone used for date and time functions.
client_min_messages: Minimum message level sent to the client. Valid values: DEBUG5, DEBUG4, DEBUG3, DEBUG2, DEBUG1, LOG, NOTICE, WARNING, and ERROR.
search_path: Namespaces in which Redpanda SQL looks for tables.
oxla.enable_fast_math: Enables math optimizations that trade precision for speed using faster, less accurate functions.

To change the number of displayed digits for floating-point values, run the query:

SET extra_float_digits TO 2;

SHOW extra_float_digits;

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

To change the minimum client message level:

SET client_min_messages TO 'WARNING';

SHOW client_min_messages;

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

To enable fast math optimizations:

SET oxla.enable_fast_math = ON;

SHOW oxla.enable_fast_math;

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

To display the current timezone setting, run:

SHOW timezone;

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

To display the current search path, run:

SHOW search_path;

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

To check the status of fast math optimizations, run:

SHOW oxla.enable_fast_math;

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

Was this helpful?