ftisiot ideas about food and life
who talks suggestions soft json-pg

How to JSON in PostgreSQL®

Published Jan 9, 2023 by in Postgresql, Json, Jsonb at https://ftisiot.net/postgresqljson/main/

This series covers how to solve common problems on JSON datasets with PostgreSQL® and it includes (links will appear once the target pages are up):

Common JSON questions

  • What are the differences between JSON or JSONB in PostgreSQL?
  • How to load JSON data in PostgreSQL?

Parse JSON

  • How to extract a field from a JSON object in PostgreSQL?
  • How to get the JSON field types in PostgreSQL?
  • How to check if JSON contains in PostgreSQL?
  • How does JSON path work in PostgreSQL?
  • How to parse JSON arrays in PostgreSQL?
  • How to parse JSON keys in PostgreSQL?

Index JSON

  • How to use GIN indexes over JSON in PostgreSQL?

Tabulate JSON to record or recordset

  • How to tabulate a JSON to a record in PostgreSQL?
  • How to tabulate a JSON to a recordset in PostgreSQL?

Convert to JSON

  • How to convert a row to JSON in PostgreSQL?
  • How to create a JSON object from keys and values arrays in PostgreSQL?
  • How to create a JSON object from array of key/value pairs in PostgreSQL?
  • How to build a JSON array from a list of elements in PostgreSQL?
  • How to convert an array to a JSON array in PostgreSQL?

Prettify JSON output

  • How to prettify the JSON output in PostgreSQL?

Edit JSON

  • How to concatenate two JSON documents in PostgreSQL?
  • How to remove fields from a JSON document in PostgreSQL?
  • How to remove an item from a JSON array in PostgreSQL?
  • How to remove nulls JSON object in PostgreSQL?
  • How to edit a JSON document in PostgreSQL?

Francesco Tisiot

Mastodon Francesco comes from Verona, Italy and works as a Senior Developer Advocate at Aiven. With his many years of experience as a data analyst, he has stories to tell and advice for data-wranglers everywhere. Francesco loves sharing knowledge with others as a speaker and writer, and is on a mission to defend the world from bad Italian food!

Story logo

© 2023