JSON_TABLE

Each syntax element is described below in more detail.

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

17 18 19 20

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

Definition PG 18

Each syntax element is described below in more detail.

Signatures and overloads

JSON_TABLE ( context_item, path_expression [ AS json_path_name] [ PASSING { value AS varname } [, ...] ] COLUMNS ( json_table_column [, ...] ) [ { ERROR | EMPTY [ARRAY]} ON ERROR] )

Each syntax element is described below in more detail.

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:120c6389614ca94a4115333dec10257a7d332801aee6bfa45b4bf885d4651528

Text language: en · wiki-repair-20261023:120c6389614ca94a4115333dec10257a7d332801aee6bfa45b4bf885d4651528