PostgreSQL Tutorial: Converting JSON documents to relational tables
Summary: in this tutorial, you will learn how to convert JSON documents to relational tables in PostgreSQL.
PostgreSQL Tutorial: Extracting JSON Data
Summary: in this tutorial, you will learn how to use the operator -> and ->> to extract an element from a JSON array or a value of a key from a JSON object.