PostgreSQL Merges JSON_TABLE(), Incremental JSON Parser
For years the PostgreSQL database server has been adding various JSON features while now the latest addition for dealing with JavaScript Object Notation (JSON) structured data is the JSON_TABLE() SQL function.
The JSON_TABLE() function allows for JSON data to be converted into a relational view that in turn can be used within FROM clauses and the like. JSON_TABLE() has been one of the last remaining JSON SQL functions not implemented by PostgreSQL MySQL / MariaDB, Oracle, and some other database solutions already offer a JSON_TABLE() function. From the new PostgreSQL documentation:
The initial JSON_TABLE() support for PostgreSQL was merged today for Git. This in turn will be part of the next major release, PostgreSQL 17.
Also merged today is a non-recursive JSON parser for PostgreSQL. This alternative JSON parser for PostgreSQL can be used for incrementally parsing data but at the cost of being slower than the recursive descent parser.
Initially making use of that new JSON parser is code for incrementally parsing backup manifests. All of this code was merged today for PostgreSQL Git.
The JSON_TABLE() function allows for JSON data to be converted into a relational view that in turn can be used within FROM clauses and the like. JSON_TABLE() has been one of the last remaining JSON SQL functions not implemented by PostgreSQL MySQL / MariaDB, Oracle, and some other database solutions already offer a JSON_TABLE() function. From the new PostgreSQL documentation:
"JSON_TABLE is an SQL/JSON function which queries JSON data and presents the results as a relational view, which can be accessed as a regular SQL table. You can use JSON_TABLE inside the FROM clause of a SELECT, UPDATE, or DELETE and as data source in a MERGE statement."
The initial JSON_TABLE() support for PostgreSQL was merged today for Git. This in turn will be part of the next major release, PostgreSQL 17.
Also merged today is a non-recursive JSON parser for PostgreSQL. This alternative JSON parser for PostgreSQL can be used for incrementally parsing data but at the cost of being slower than the recursive descent parser.
Initially making use of that new JSON parser is code for incrementally parsing backup manifests. All of this code was merged today for PostgreSQL Git.
Add A Comment