例如
select row_to_json(row(productid, product)) from gtab04;
这将返回低于结果的结果
row_to_json
---------------
{"f1":3029,"f2":"DIBIZIDE M TAB"}
{"f1":3026,"f2":"MELMET 1000 SR TAB"}
{"f1":2715,"f2":"GLUCORED FORTE"}
{"f1":3377,"f2":"AZINDICA 500 TAB"}
- 不幸的是,它丢失了字段名,并用f1、f2、f3等替换它们.
- 如何获得实际的字段名或演员字段名?