16 Working with JSON Data
JavaScript Object Notation (JSON) is a widely used text format for storing data in a platform-independent way so it can be shared between computer systems. In this chapter, you’ll learn the structure of JSON as well as how to store and query JSON data types in PostgreSQL. After we explore PostgreSQL’s JSON query operators, we’ll analyze a month’s worth of data about earthquakes.
The American National Standards Institute (ANSI) SQL standard added syntax definitions for JSON and specified functions for creating and accessing JSON objects in 2016. Major database systems have added JSON support in recent years as well, ...
Get Practical SQL, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
