GaussDB将JSON字符串转为对象并取某个字段的值

select jsonb_extract_path_text(json_param::jsonb, 'param_a') as param_a from json_test_table;