Mission Critical Databases

Webinar: Introduction to JSON data types in PostgreSQL


The webinar was held on December 12, 2017 and covered 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 

Speaker: Andrew Dunstan | Principal Contributor of JSON functionality to PostgreSQL


Introduction to JSON data types in PostgreSQL_Large

Andrew Dunstan has been involved with PostgreSQL since his first contribution in 2003. In 2004 he created the PostgreSQL Build Farm system, which he has maintained ever since, and in 2005 he was made a core committer of the PostgreSQL project. He has contributed many features to PostgreSQL, including the Windows port, dollar quoting, CSV import and export, PL/Perl enhancements, CSV logging, parallel pg_restore and enum extension.