doufei0933
2017-09-09 22:44
浏览 65
已采纳

如何在golang的postgres中检索第一行的json的键?

I currently have a table like this

id | value
----------
1  | {"key1":"value1", "test1":"value3"}
2  | {"key1":"value2", "test1":"value4"}

I would like this returned

key1, test1

The keys are the same in each row, but the number of keys may change.

I tired using

SELECT jsonb_object_keys(value) FROM mn_statistics_company

however, that got me all the keys of all the json of that row key1 test1 key1 test1

and have tired

SELECT value FROM mn_statistics_company LIMIT 1

but that just returns the json with both the key and values.

{"key1":"value1", "test1":"value3"}

图片转代码服务由CSDN问答提供 功能建议

我目前有一个这样的表

  id | 值
 ---------- 
1 |  {“ key1”:“ value1”,“ test1”:“ value3”} 
2 |  {“ key1”:“ value2”,“ test1”:“ value4”} 
   
 
 

我要返回此

   key1,test1 
   
 
 

每行中的键相同,但是键的数量可能会更改。

我很累使用

  SELECT jsonb_object_keys(value)从mn_statistics_company 
   
 
 

,但是,这给了我所有的键 该行的所有json中的 key1 test1 key1 test1

并已厌倦

  SELECT值FROM  mn_statistics_company LIMIT 1 
   
 
 

,但这仅返回带有键和值的json。

  {“ key1  “:” value1“,” test1“:” value3“} 
   
 
  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

1条回答 默认 最新

相关推荐 更多相似问题