Presented by:
Dave Stokes
Dave Stokes is the author of MySQL & JSON - A Practical Programming Guide
No video of the event yet, sorry!
Data in JSON format can become problematic. First, it breaks your data normalization. Send, most of the SQL functions you know and love do not work with JSON. But there are legitimate reasons to use JSON for storage. And there is a way to temporarily transform your JSON data for processing with SQL. JSON_TABLE() makes your JSON data available for use with all the PostgreSQL commands you are used to using. You will learn the basic syntax of this command. Then you will learn how do deal with missing data (required fields are usually not enforced in JSON) , the intricacies of nested paths in the JSON document, and error handling. So if you need to store data in JSON but need to process that data with SQL, you need to be in this session.
- Date:
- 2026 March 26 10:00 EDT
- Duration:
- 1 h 30 min
- Room:
- Google Meet or Riverside
- Conference:
- PostgresWorld Training 2026
- Language:
- Track:
- Essentials
- Difficulty:
- Medium
- Requires Registration:
- Yes (Registered: 0)