数据仓库服务 GAUSSDB(DWS)-配置设置函数:current_setting(setting_name)

时间:2024-04-18 16:25:16

current_setting(setting_name)

描述:当前的设置值。

返回值类型:text

备注:current_setting用于以查询形式获取setting_name的当前值。和SQL语句SHOW是等效的。比如:

1
2
3
4
5
6
SELECT current_setting('datestyle');

 current_setting
-----------------
 ISO, MDY
(1 row)
support.huaweicloud.com/sqlreference-830-dws/dws_06_0053.html