Updated on 2023-10-23 GMT+08:00

Configuration Settings Functions

Configuration setting functions are used for querying and modifying configuration parameters during running.

  • current_setting(setting_name)

    Description: Specifies the current setting.

    Return type: text

    Note: current_setting obtains the current setting of setting_name by query. It is equivalent to the SHOW statement.

    Example:

    1
    2
    3
    4
    5
    6
    openGauss=# SELECT current_setting('datestyle');
    
     current_setting
    -----------------
     ISO, MDY
    (1 row)
    
  • set_working_grand_version_num_manually(tmp_version)

    Description: Upgrades new features of the database by switching the authorization version.

    Return type: void

  • shell_in(type)

    Description: Inputs a route for the shell type that has not yet been filled.

    Return type: void

  • shell_out(type)

    Description: Outputs a route for the shell type that has not yet been filled.

    Return type: void

  • set_config(setting_name, new_value, is_local)

    Description: Sets the parameter and returns a new value.

    Return type: text

    Note: set_config sets setting_name to new_value. If is_local is set to true, new_value applies only to the current transaction. If you want new_value to apply for the current session, set the value to false instead. The function corresponds to the SET statement.

    Example:

    1
    2
    3
    4
    5
    6
    openGauss=# SELECT set_config('log_statement_stats', 'off', false);
    
     set_config
    ------------
     off
    (1 row)