Functions / System Administration Functions

set_config

Sets the parameter setting_name to new_value, and returns that value.

Reading PG 18current·documented in 25 of 27 versions, 7.3 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

set_config ( setting_name text, new_value text, is_local boolean ) → text

Sets the parameter setting_name to new_value, and returns that value. If is_local is true, the new value will only apply during the current transaction. If you want the new value to apply for the rest of the current session, use false instead. This function corresponds to the SQL command SET.

set_config('log_statement_stats', 'off', false) → off

Version history 4

12 → 13 changed
7.4 → 8.0 changed
7.3 → 7.4 changed
7.2 → 7.3 added

Definition snapshot: b7bd9cda · English manual source