Functions / System Administration Functions

current_setting

Returns the current value of the setting setting_name.

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

current_setting ( setting_name text [, missing_ok boolean ] ) → text

Returns the current value of the setting setting_name. If there is no such setting, current_setting throws an error unless missing_ok is supplied and is true (in which case NULL is returned). This function corresponds to the SQL command SHOW.

current_setting('datestyle') → ISO, MDY

Version history 6

12 → 13 changed
9.5 → 9.6 changed
8.3 → 8.4 changed
7.4 → 8.0 changed
7.3 → 7.4 changed
7.2 → 7.3 added

Definition snapshot: b7bd9cda · English manual source