System administration functions

current_setting()

Returns the current value of a specified system administration setting. This function corresponds to the SQL command SHOW.

Syntax

current_setting ( setting_name string ) → string

Example

SELECT current_setting ('server_version');
---------RESULT
 current_setting 
-----------------
 8.3.0
(1 row)

Supported system administration settings

We are adding more settings to the list. Currently, the following settings are supported:

• server_version
• server_version_num
• timezone
• query_mode
• streaming_parallelism
• batch_parallelism