JSON_TABLE() Will Be in PostgreSQL 17
JSON_TABLE() will be in PostgreSQL 17! It almost made it two years ago but was yanked away at the last minute. We will get it shortly when PostgreSQL 17 is officially released this year! Please see this.Why is this important?JSON has become the data interchange format of choice for most developers. JSON had a litany […]
PostgreSQL 17将引入JSON_TABLE()，使处理JSON数据更加方便。JSON_TABLE()可以将JSON数据转换为关系表，以便使用SQL命令进行处理。然而，PostgreSQL的JSON_TABLE()无法处理嵌套列。希望将来能够加入JSON模式验证等功能。
