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

array

Jan 10, 2023

How to remove an item from a JSON array in PostgreSQL®?

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the - operator to remove an item from an array.

Continue Reading

Jan 9, 2023

How to create a JSON object from array of key/value pairs in PostgreSQL®?

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the function json_object (jsonb_object for JSONB) to create a JSON object from an array of key/value pairs.

Continue Reading

Jan 9, 2023

How to create a JSON object from keys and values arrays in PostgreSQL®?

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the function json_object (jsonb_object for JSONB) to create a JSON object from two arrays of keys and values.

Continue Reading

Jan 9, 2023

How to convert an array to a JSON array in PostgreSQL

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the function array_to_json (array_to_jsonb for JSONB) to create a JSON array from an existing array.

Continue Reading

Jan 9, 2023

How to build a JSON array from a list of elements in PostgreSQL®

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the function json_build_array (jsonb_build_array for JSONB) to create a JSON array from a list of elements.

Continue Reading

Jan 9, 2023

How to parse JSON arrays in PostgreSQL?

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, and provides several different ways to parse arrays from a JSON document:

Continue Reading


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