PostgreSQL Tutorial: Best Practices for JSON Data Type
Summary: In this tutorial, you’ll learn best practices and architecture guide for the JSON data type in PostgreSQL.
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.