PostgreSQL 17: Convert JSON to Tables Easily with JSON_TABLE

PostgreSQL 17 finally introduces the standard JSON_TABLE function! In this tutorial, I'll show you how to transform complex JSON data into a relational table format without the headache of older nested functions. PostgreSQL JSON to table PostgreSQL json_table function Working with JSON data in PostgreSQL JSONB tutorial PostgreSQL PostgreSQL JSON column to table PostgreSQL query JSON efficiently timestamp --------------------------- 0:00 intro software nuggets 0:03 introduce json_table function 0:17 download source from github 0:37 create table to store json 0:55 insert JSON into table 1:29 select * from table (see the json) 1:52 use json_table function 6:30 second example of using json_table 6:58 closing remarks - leave comment / thumbs up @softwareNuggets, #softwarenuggets PostgreSQL 17 new features, JSON_TABLE tutorial, Postgres JSON to SQL, query JSONB postgres, SQL JSON functions 2024