jsonb_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.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

jsonb_each_text ( jsonb ) → 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:00cc0bffde9e8377f07378b471d5e949b7a33ee0016b4a8c875433b49819a298

Text language: en · wiki-repair-20261023:00cc0bffde9e8377f07378b471d5e949b7a33ee0016b4a8c875433b49819a298