The video of my presentation below walks you through the major features of the native JSON data type in PostgreSQL 9.3 and beyond.

This presentation covers the following topics:

  • What is JSON?
  • How is it available in PostgreSQL?
  • What’s the difference between JSON and JSONB?
  • Accessing JSON values
  • Creating JSON from table data
  • Creating table data from JSON
  • Crosstabs with JSON
  • Indexing and JSON
  • When to use JSON, when to use JSONB, and when neither should be used