Atitit postgre sql json使用法 目录 1.1.1. 插入数据 1 2. json数据的常见操作 1 1.1.1.插入数据 插入数据可以直接以json格式插入： insert

Op

Postgre实现

Demo

Get JSON object field by key

Get JSON array element 

->

Get JSON object field as text

->>

Get JSON array element as text

->>

Get JSON object at specified path

#>

json_extract_path

Get JSON object at specified path as text

##>

exist as a top-level key

?

 these array strings exist as top-level keys是否存在系列key

?|

Do all of these array strings exist as top-level keys?

?&

Delete key/value

-

Delete the field or element with specified path

#-

Str_to json

to_json(anyelement)

array_to_jso

Rs row to json

row_to_json

Arr to json

json_build_array

json_build_object

Json_Str to json

json_object

\

json_each

json_each_text

json_object_keys

Json to rs

json_populate_record

json_to_record