5mins of Postgres E13: New SQL/JSON and JSON_TABLE features in Postgres 15

Опубликовано: 29 Сентябрь 2024
на канале: pganalyze
1,239
39

In today's episode, we take a look at the SQL/JSON features in Postgres 15. Postgres 15 will most likely be released in September or October, so it's still quite a way until we can actually use this on a production server. However, a couple of days ago, the Postgres 15 feature freeze occurred, which means we now have a good sense for which functionality will make it into this next Postgres release.

Find the article on our blog here: https://pganalyze.com/blog/5mins-post...

Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
  / pganalyze  

📑 What we have discussed in this episode of 5mins of Postgres:

Waiting for PostgreSQL 15 – Documentation for SQL/JSON features: https://www.depesz.com/2022/04/08/wai...

SQL/JSON constructors: https://www.depesz.com/2022/03/31/wai...

IS JSON predicate: https://www.depesz.com/2022/04/01/wai...

SQL/JSON query functions: https://www.depesz.com/2022/04/01/wai...

JSON_TABLE: https://www.depesz.com/2022/04/06/wai...

JSON Functions and Operators - JSON_TABLE: https://www.postgresql.org/docs/devel...