SET/SHOW statement

Overview

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

Syntax

SET Syntax

SET <option> TO <value>;

SHOW Syntax

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 extra_float_digits.

• 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.

Examples

Case #1: SHOW Statement

Example 1

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

SHOW timezone;

This will display the current timezone setting.

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

Example 2

To display the current search path, use the following query:

SHOW search_path;

This will display the current search path setting.

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

Case #2: SET Statement

Example 1

To change the number of digits, use the SET statement below:

SET extra_float_digits TO 2;

This will set the number of digits displayed for floating-point values to 2.

SHOW extra_float_digits;

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

Example 2

To change the client message, use the SET statement below:

SET client_min_messages TO 'WARNING';

This will set the message level to ‘WARNING’.

SHOW client_min_messages;

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