json_each_text

Expands the top-level JSON object into a set of key/value pairs. The returned values will be of type text.

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

group: json
group label: JSON 函数和操作符
lang: en
layout: table-new
pages: functions-json.html
prose only: false

Definition PG 18

Expands the top-level JSON object into a set of key/value pairs. The returned values will be of type text.

Signatures and overloads

json_each_text ( json ) → setof record ( key text, value text ) → setof record

Expands the top-level JSON object into a set of key/value pairs. The returned values will be of type text.

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"functions-json.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"060b67147827d70ddcf5948833ddfbeada321366476016c8b8b7d68afda8045c","version":"18.7"},{"file":"functions-json.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"31b98fa7f00387abf441728c31918bfe8b368642bceeb8bba88a73c3fbd607de","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:8cba84551dd458e16116bffd5ddeeb6fa0feaeb1e65fe195ccb9f5e9e894bc43

Text language: en · wiki-repair-20261023:8cba84551dd458e16116bffd5ddeeb6fa0feaeb1e65fe195ccb9f5e9e894bc43