考虑 正则表达式

benchmarksql=# select * from bmsql_config where cfg_name ~* 'warehouses';
cfg_name | cfg_value
------------+-----------
warehouses | 20
(1 row)

benchmarksql=# select * from bmsql_config where cfg_name ~* 'WAREHOUSES';
cfg_name | cfg_value
------------+-----------
warehouses | 20
(1 row)